Tag Archive for: dbExpress

CopyReaderToClientDataSet after XE2 – Where are you?

CopyReaderToClientDataSet copies the contents of a TDBXReader into a TClientDataSet instance. It returns the same TClientDataSet instance that was passed to this method. CopyReaderToClientDataSet is part of the Data.DBXDBReaders.TDBXDataSetReader class until Delphi/C++Builder XE2, however in XE3 it changed a little bit, it became part of a new class called Data.DBXCDSReaders.TDBXClientDataSetReader. I got several e-mails from my blog readers that downloaded some of my […]

Read more

Controversial changes in the EULA for Delphi XE3 and C++Builder XE3

Categories:C++Builder, DelphiTags: , ,

As everybody knows Delphi XE3 will be released soon, some previews have been already published and there are some controversial topics around XEe, mostly because of leaks from people that clearly violated the NDA and this is shameful. The biggest controversy is the new license agreement (EULA) that leaked this week, where new users can […]

Read more

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 text fields when using the CopyReaderToClientDataSet […]

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 use Data Aware components or bi-directional datasets. There are situations where you will need to copy data from DBXReader to TClientDataSet or TParams, for this kind of situation Delphi has the unit DBXDBReaders.pas, which contain some […]

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