C++

New CData FireDAC drivers

Author: Pawe Gowacki It is very exciting time for Delphi and C++Builder developers! Embarcadero just announced partnership with CData to provide the whole suite of new FireDAC drivers that provide connectivity to major APIs and web services. The list of new FireDAC drivers is quite long and includes connectors to over 80 systems, like Amazon DynamoDB, SalesForce, Microsoft Dynamics, Google Big…
Read more
C++

FireDAC & ODBC for Paradox and dBase tables.

I continue to get customer requests for options to migrate legacy RAD Studio, Delphi or C++ Builder applications using the Borland Database Engine (BDE) with Paradox and/or dBase files. With the current versions of RAD Studio…
C++

New in 10.2: MariaDB Support

Author: Pawe Gowacki One of the biggest new RAD Studio 10.2 Tokyo database features is support for MariaDB open-source relational database. MariaDB is one of the most popular open-source SQL databases. It is a fork from MySQL database, after it has been acquired by Oracle, the original creators of MySQL, started to work on MariaDB, which is highly compatible, some say 95%, with MySQL. Consequently…
Read more
Delphi

Using Delphi, from Excel to JSON, then FireDAC[JAPAN]

Author: John D7279 //// class function ExcelToJson(cells: TRect; excel_filename, sheet_name: String):TJSONObject; It is a code for excel to JSON. //// class function TExcelToFireDAC.ExcelToJson(cells: TRect; excel_filename, sheet_name: String): TJSONObject; const def_excel_application = 'Excel.Application'; var jres: TJSONObject; jline: TJSONObject; ExcelApp…
Read more
C++

Using FireDAC Unidirectional property for fast, low memory selection set processing

I often do large Oracle database queries using FireDAC to analyze registration data about our products and customers. Most of the time I am only processing through millions of rows to create a report or chart. One of the FDQuery properties that I forget to set True is the TDFQuery’s “Unidirectional” sub-property found under the FetchOptions (TFDFetchOptions) property. By…
Read more