Tag Archive for: dbExpress

Using dbExpress Framework on Windows and Mac with C++Builder

During the following weeks I’m writing a series of C++ examples to demonstrate the use of VCL, FireMonkey, RTL, dbExpress, and others stuff. Each example will have a major focus, but you will be able to learn other stuffs as well. If there is something specific on C++ you would like to see, please let [...]

Read more

CopyReaderToClientDataSet, Blob and the message “Feature not implemented”

If you have used the method TDBXDataSetReader.CopyReaderToClientDataSet, you probably came across with the message “Feature not implemented”, this exception occurs because the method CopyReaderToClientDataSet can’t copy Blob fields from the DBXReader to the ClientDataSet. This is no longer a problem, Delphi XE2 Update 2 changed this behavior and now supports Blob fields when using the CopyReaderToClientDataSet method. [...]

Read more

Connecting to PostgreSQL through dbExpress ODBC driver

Delphi XE2 and C + + Builder XE2  introduce the new dbExpress ODBC driver, which enable FireMonkey and VCL applications to connect to any database that provides a ODBC driver. In order to show how it works, I created a FireMonkey project sample that connect to a PostgreSQL database. As first step, you must install the PostgreSQL ODBC driver [...]

Read more

Copying data from ClientDataSet to DBXReader

Categories:C++Builder, DelphiTags: , ,

You probably already read my post Copying data from DBXReader to ClientDataSet, now is time to learn how copy data from ClientDataSet to DBXReader using Delphi or C++Builder. There are many situations where you will need to copy data between ClientDataSet and DBXReader, specially if you are looking to cache data on DataSnap Servers, I’m [...]

Read more

Parameterized queries with dbExpress (DBX) Framework

Categories:DelphiTags: ,

In order to answer a question from two Brazilian developers about how to use parameterized queries using dbExpress Framework I decided to write this post. Let start understanding the small difference between parameterized queries using DBX Framework and VCL. While VCL uses “:PARAMETER” to define query parameters, DBX Framework represent parameter as “?”, and it [...]

Read more

Copying data from DBXReader to ClientDataSet

Categories:DelphiTags: , ,

If you are using DataSnap 2010/XE for sure use DBXFramework, which I strong recommend for operations where you don’t Data Aware components or bi-directional datasets. In some cases is necessary to copy content from DBXReader to TClientDataSet or TParams, for this situation Delphi has the unit DBXDBReaders.pas, which include some classes that allow this kind [...]

Read more

Video: New dbExpress driver for Firebird in Delphi 2010 and C++Builder 2010

Categories:DelphiTags: , , , ,

Ok, the Firebird community asked for and now they have in RAD Studio 2010 a new dbExpress driver for Firebird, full support including the dbExpress framework, check this video out. For more information about RAD Studio 2010 click here Also I recommend you to watch the new sneak peek video about other new database features [...]

Read more