Subscribe to this list via RSS Blog posts tagged in FireDAC
Enterprise Connectors + FireDAC で実現できる様々なデータ連携 [JAPAN] 2017年9月より販売を開始した Enterprise Connectors ですが、これを利用すると多彩なアプリケーションデータへ FireDAC からアクセスできるようになります。 このデータアクセスですが、単にエンタープライズデータを参照したり、データを追加更新することもできるわけですが、それはあくまで Enterprise Connectors の基本機能にすぎません。では、Enterprise Connectors のデータ連携の例を幾つか紹介してみましょう。
Дополнительные утилиты FireDAC Последнее время большую часть рабочего времени пришлось уделить разработке новых примеров для недавно включенной в состав RAD Studio библиотеки компонент для доступа к Google Drive и другим корпоративным ресурсам. Об этом и получившихся приложениях я напишу отдельно в одном из следующих постов. Работа с Google Drive в этой библиотеке основана на компонентах FireDAC и практически все сложности были связаны с корректной настройкой синтаксиса и параметров различных SQL запросов, а также их исполне...
Convert CSV file to TFDMemTable format JSON file.   Convert from CSV file to “JSON file” of “TFDMemTable format”. This program uses C++Builder 10.2 Tokyo Release 1. include #include <iostream> #include <fstream> #include <string> #include <codecvt> #include <FireDAC.Comp.Client.hpp> #include <FireDAC.Stan.StorageJSON.hpp> #include <FireDAC.Stan.Intf.hpp> #include <memory> #include <vector> #include <sstream> #include <mutex> #include <...

Posted by on in Blogs
Deploying InterBase 2017 ToGo on Mac OS X InterBase 2017 ToGo Edition is a full-featured, multi-device embeddable database for Windows, Linux and macOS that runs in a stand-alone environment but allows deployment of applications which directly utilize the InterBase engine DLLs. With no separate database server process running, the database engine executes in the application process space providing an extremely small footprint. Together with other key features such as high security, zero administration, and simple installation, InterBase...
FireDAC:  Mac OS X Client connecting to InterBase Server on Windows Mac client vs PC client, which is better?   With RAD Studio, Delphi or C++ Builder it really does not matter!   Building your app in RAD Studio eliminates the need to engage in multiple development efforts for the same application on multiple devices. This means you get to market faster on multiple devices for the first release – and every release after that – while keeping costs down.   RAD Studio speeds and simplifies OS X application development for Windows developers. D...
Moving BLOB fields from one SQL Database into InterBase database using FireDAC In general, there is no difference between moving non-BLOB and BLOB fields into an InterBase database, so any technique may be used, depending on your needs: 1. One technique is to use two regular TFDQuery components; one TFDQuery will read with SELECT, and another will write with INSERT / UPDATE. The process is as follows: 1) Read the data from a FireDAC query into a RAD Studio, Delphi or C++ Builder application from a SQL Database. 2) Push the data via a FireDAC connection into an InterBase...
C++ Builder - Creating InterBase database on the fly at run-time using FireDAC Sometimes you have the need to create your InterBase database on the fly in code at runtime, for example, if a user downloads your application and runs the application for the first time, and your app needs to create and use a database with the application.  On Single or Multi-Device platforms, this would save you from having to deploy the database file and also setup the paths for deployment reducing your upfront work.   From Connect to InterBase (FireDAC), looks like ...

Posted by on in Tutorial
Twitter Enterprise Connector in Action Update Subscription customers can join the beta and download beta builds for 70+ Enterprise Connectors via the GetIt Package Manager for RAD Studio 10.2.  In today's post, I thought I would highlight how easy it is to create an application that shows your Twitter feed.   Step 1)  Create a new app at apps.twitter.com Login using your Twitter account credentials and select "Create an application". Enter your app name, description and website URL. Set the Callback URL to ...
InterBase フィールドレコードの自動インクリメント[JAPAN] InterBase 2017で テーブルフィールドの自動インクリメント 下記の様なテーブルがあったとして create_table.sql -- #t1 テーブル作成 create table t1( num_ int not null, name_ varchar(50) not null, primary key(num_) ); t1テーブル field名 型 null / PK num_ int not null (PK) name_ varchar(50) not null trigger作成 新しくtriggerとgeneratorを作成、triggerにはt1テーブルを割り当てます。 create_generator_trigger.sql -- #generator作成 create generator sq1; -- #t1テーブルのinsert前に tr1トリガーを作る create trigger tr1 for...
CodeRage 2017: Aufzeichnungen der Zweiten Deutschen CodeRage Die CodeRageDE (Zweite Deutsche CodeRage) war gestern ein voller Erfolg! Viele Interessante und ausgiebige Vorträge zu den Themen Delphi, C++Builder, modernes C++, TMSPassKit, FireDAC Cached Update, Linux Entwicklung mit Apache, Facebook Login mit Delphi, Neuerungen in 10.2 Tokyo, Komponentenentwicklung, und und und.... Vielen Dank an die Präsentatoren und die Klimaanlage, die es mir persönlich ermöglicht hat, den Tag mit Spaß und Freude zu überleben :-) Die Playlist findet sich hier (alle Vid...

Check out more tips and tricks in this development video: