I was recently make aware of an undocumented feature that's been in InterBase for more than 2 decades. It's the fact that every row in every table has a unique identifier. I think it is best thought of as a Raw Record position. This field is called RDB$DB_KEY. RDB$DB_KEY is an array of 16 bytes. Array's are handled differently with different drivers so you have to cautious about how you use this data type. However, RDB$DB_KEY provides the fastest access to uniquely identify a row in a table, so ...
I was recently asked by a customer for tips on making the fastest bulk insert. Here are my thoughts on the subject
Turn off inserts and check constraints. This one is by far the most important.
Perform a commit approximately every 10,000 rows. 10,000 is no absolute magic number, but is a good water mark.
Don't prepare every insert statement. It needs to be prepared just once.
Use the Batch API as discussed here: http://docwiki.embarcadero.com/InterBase/XE7/en/Using_Batch_Updates_to_Submit_...
In my recent CodeRage X talk I presented many examples of ODBC connectivity. However, there was a some more I wanted to say, but did not have time to do so. So, below is that content.
ODBC administrator has a 64 bit and 32 bit version on 64 bit versions of Windows. If you are using ODBC administrator from Control Panel, you are using the 64 bit version. To run the 32 bit version, you need to run c:\windows\syswow64\odbcad32.exe. The settings you make in the 64 bit or 32 bit version of ODBC ad...
С огромным удовлетворением хочу известить всех, что компания Embarcadero Technologies выпустила новую версию одного из лучших инструментов разработки кросс-платформенного программного обеспечения, популярнейшего продукта RAD Studio! Новый продукт теперь носит имя RAD Studio 10 Seattle, для друзей - просто "десятка".
Состав RAD Studio практически не поменялся, по-прежнему, полный набор включает Dephi, C++Builder, HTML5 Builder и InterBase. Зато набор поддерживаемых платформ расширен для поддержк...
Today's (June 3, 2014) Developer Skill Sprint by Jim McKeeth shows you how to use App Tethering to control a Windows app from a mobile device. From the DocWiki: The RTL provides new App Tethering components to give your applications the ability to interact with other applications running either on the same machine or on a remote machine. You can use App Tethering in your VCL and FireMonkey applications.
Using App Tethering, your applications can:
Discover other applications that support a...
Today's (May 29, 2014) Developer Skill Sprint by John Thomas (JT) covers how to use C++ packages in your 64-bit Windows applications. From the DocWiki: C++Builder XE6 now supports the production of packages for 64-bit Windows. Previously, C++Builder supported production of packages only for 32-bit Windows. The BCC64 compiler produces .bpl files for Win64. Note that C++Builder does not produce dylibs for the Mac, or packages for the iOS and Android platforms. For these platforms, static libraries...
I was reading a StackOverflow question and answer in the Delphi group and spotted this one: "How to get the currently logged in username". Here is a C++Builder XE5 version of similar coding that gets the logged in user name Windows and Mac OSX. For iOS the code gets the iPhone's name using the Objective-C bridge.
//---------------------------------------------------------------------------
#include <fmx.h>
#pragma hdrstop
#include "DesktopMainForm.h"
#if defined(TARGET_OS_IPHONE)
#in...
It's three weeks until our CodeRage 8 C++ online technical conference starts. On Tuesday and Wednesday, February 25 and 26 (6am to 6pm each day) C++ industry and Embarcadero technology experts will present 24 educational sessions covering C++Builder XE5 including building applications for Windows, OS X and iOS. The technical session schedule is listed at http://www.embarcadero.com/coderage/coderage-8-c-plus-plus-sessions. We are still putting the finishing touches on the complete lineup and if y...
As part of our recent "Making the Connection: Programming Devices and Gadgets with RAD Studio" (https://www.embarcadero.com/rad-in-action/programming-devices-and-gadgets) I showed developers how to use the REST Client Library components with Delphi XE5. In this blog post I'll show you a C++Builder XE5 FireMonkey application that I built to find and control the same lights. The application uses the REST Client Library components (the Philips Hue lights SDK supports REST/JSON), Project Indy TIdHTT...
It's 2014. On April 8, 2014, Microsoft will stop supporting Windows XP (Microsoft recently announced that they will continue to provide virus warnings until summer 2015). By moving, now, to RAD Studio XE5, Delphi XE5 and C++Builder XE5 you can move your apps forward to Windows 7 and 8 and take advantage of many of the new Windows features with support already built into our latest releases. You can also expand the reach of your apps to Mac OS X, iOS and Android. Before your customers and users e...