Latest Articles

More 2017 FireDAC Webinars

Written by Jim McKeeth on . Posted in Articles

To follow up with our recent FireDAC in Depth with Cary Jensen we have a series of FireDAC webinars to help you learn more about everyone's favorite database access framework. Each webinar is offered at 8 AM, 1 PM and 8 PM US Central Time to provide access in all timezones. 


  • 25-Jul (Tue) FireDAC Introduction
    • An introduction to the multi-platform, multi-database, full featured, super fast database access framework.
  • 27-Jul (Thu) FireDAC Tracing and Monitoring
    • How to use FireDAC's Tracking and Monitoring features for advanced logging and troubleshooting.
  • 01-Aug (Tue) FireDAC Cached Updates and Autoinc Fields
    • Learn to use autoincrement fields as primary keys, and cached updates to cache multiple updates in memory and write them all to the database at a later time in a single batch.
  • 03-Aug (Thu) FireDAC Array DML
    • The Array DML execution technique submits a single DBMS command with an array of parameters. Each command parameter has an array of values, and all parameters have arrays of the same length. Then FireDAC requests the DBMS to execute a command once for each row in arrays. This technique reduces the amount of communication between DBMS and client, enables DBMS to stream command execution, and speeds up execution time.
  • 08-Aug (Tue) FireDAC Cascading Options System
    • Learn to use the cascading system of setting options for optimal FireDAC performance
  • 10-Aug (Thu) FireDAC: Preprocessing SQL Commands
    • FireDAC Preprocessing includes "macro" and "escape sequence" allowing dynamic generation of more complex sets of operations for performance and less work on the developer's part.
  • 15-Aug (Tue) FireDAC ETL = Extract, Transform, Load
    • The FireDAC Extract, Transform and Load functions work with the batch move, reader and writer components for data movement between different types of data sources and the data destinations.
  • 17-Aug (Thu) FireDAC In Memory DataSets: TFDMemTable
    • The FireDAC in memory data set lets you work with an offline or in memory dataset with being connected to a database. This can be helpful in a briefcase model, or when adding dataset functionality to a non-database driven application.
  • 22-Aug (Tue) FireDAC Local SQL
    • Local SQL gives you the full power of SQL based set operations across datasets from diverse sources, including different databases, different data engines and in memory data.
  • 24-Aug (Thu) Migrating BDE applications to FireDAC and InterBase
    • Learn how to migrate your legacy BDE based database application to FireDAC and InterBase to keep your programs relevant and to take advantage of all the new features and functionality.
  • 29-Aug (Tue) Migrating dbExpress Applications to FireDAC
    • Learn how to migrate away from dbExpress to give your applications the full power of FireDAC
  • 31-Aug (Thu) Using InterBase Events and Change Views with Callback Functions
    • Get more power from InterBase with events, change views and call back functions.

Viewing Salesforce Data in RAD Studio Data Explorer

Written by Sarina D on . Posted in Articles

How to view Salesforce data in RAD Studio Data Explorer using the Enterprise Connectors for Salesforce.

With the Enterprise Connectors for Salesforce, you gain access to live Salesforce data within RAD Studio, abstracting the data into tables, views, and stored procedures that can be used to both retrieve and update Salesforce data. This article will walk through connecting to Salesforce using the Data Explorer.

Connecting to Salesforce Data Using Data Explorer

You can create a simple application for displaying Salesforce data by utilizing the Enterprise Connectors for Salesforce and a new VCL Forms Application:

  1. Open the Data Explorer in RAD Studio and expand FireDAC.
  2. Right-click on CData Salesforce Data Source and click Add New Connection.

  3. Name the connection.
  4. Fill in the necessary connection parameters and click OK. 


    There are several authentication methods available for connecting to Salesforce: Login, OAuth, and SSO. The Login method requires you to have the username, password, and security token of the user.

    If you do not have access to the username and password or do not wish to require them, you can use OAuth authentication.

    SSO (single sign-on) can be used by setting the SSOProperties, SSOLoginUrl, and TokenUrl connection properties, which allow you to authenticate to an identity provider. See the "Getting Started" chapter in the help documentation for more information.


  5. Back in the Data Explorer, expand the tables for the connection.
  6. Create a new VCL Forms application and drag a table (for example: Account) onto the form.

  7. Select the AccountTable object on the form and set the Active property to true.
  8. Right-click on the object, bind visually, and link everything (*) to a new control (TStringGrid).

  9. Arrange the TStringGrid on the form and run the application to see the Account data.

Ready to try the Enterprise Connectors? Download the beta builds today. Just open RAD Studio 10.2, navigate to Tools > GetIt Package Manager and select from over 70 connectors. Requires RAD Studio Pro or higher editions.


Written by Hitoshi Fujii on . Posted in Tutorials




Delphiは、単体製品としても、またC++Builderを含むスイート製品RAD Studioの一部としても提供しています。Delphiをすぐに使い始めるには、2つの方法があります。


Delphi Starter Editionは、無料で利用できるDelphiです。趣味や学習を目的とした利用のほか、Delphiによって開発したアプリケーションに関連する収益が、1,000 USドルを越えないというライセンス規定で利用できます。Starter Editionは、Win32開発をサポートしているので、基本的な学習や言語の取得に最適です。

Starter Editionは、 からダウンロードできます。


RAD Studioの30日トライアル版をダウンロードすれば、Delphi / RAD Studioのすべての機能を30日間試用することができます。トライアル版の使用が終了したら、正規のライセンスを購入して開発を続けることができます。


トライアル版は、 からダウンロードできます。


Delphiを本格的に利用する場合には、製品版をお求めください。製品版には、目的別に3つのエディションがあります。また、RAD Studioを選択すれば、C++Builderが利用できるほか、Professional版でもモバイル開発を行うことができます。


オンラインで閲覧できる「RAD Studio入門」ページには、Delphi / RAD Studioを初めて使う人が参考になるさまざまな情報が掲載されています。

Delphi / RAD StudioのオンラインヘルプはDocWikiと呼ばれ、継続的にアップデートされています。ドキュメントのオリジナル言語である英語のほか、日本語、ドイツ語、フランス語に翻訳されています。

How Toビデオシリーズ」は、Delphi / C++Builder / RAD Studioのインストール、設定から、基本的な開発ステップ、各種機能の使い方までを解説したビデオ学習教材です。

Delphi / RAD Studioのコードサンプルは、製品とともにインストールすることができますが、数多くのサンプルコードがSourceForgeにも登録されています。XE以降の各バージョンごとのサンプルにもアクセスできます。



移行の手順やWindows 10サポートの方法などを解説する無料セミナーも開催しています。参加は無料。ぜひご参加ください。


Delphi Starter / C++Builder Starterを用いた入門者向けのオンラインセミナーを開催。ゲームを作りながら、ビジュアル開発/オブジェクト指向開発の基礎を学びます。













Written by Hitoshi Fujii on . Posted in News


1) セッションスピーカー


  • Delphi、C++などの開発言語、ツール活用のテクニック、チュートリアル
  • 旧バージョンからの移行TIPSなど
  • モバイルやタブレット向け開発、クロス開発など、新しいプラットフォームへの適用例
  • 関連する技術(データベース、ミドルウェア、IoT、ツール)の活用テクニック
  • Delphi/C++Builderユーザーの視点から見たエンバカデロのデータベースツール活用例
  • 最新のソフトウェア開発技術に関する情報
  • 最新バージョンを適用した開発例
  • エンバカデロ製品を利用した開発事例、技術的ポイントの紹介

申込方法:デベロッパーキャンプのセッションスピーカーを希望される方は、This email address is being protected from spambots. You need JavaScript enabled to view it.まで、「第34回デベロッパーキャンプ講師応募」という件名で、以下の情報を記載したメールをお送りください。

  • 氏名(フリガナ)
  • 会社名
  • 部署名
  • 役職
  • プロフィール
  • メールアドレス
  • 電話番号
  • 講演内容案(テーマ/セッション概要など)
  • 対象製品/言語
  • セッションタイプ(チュートリアル/テクニカル/ケーススタディ/プレビュー/その他)
  • 講演希望場所: 東京 および/または 大阪


2) ライトニングトーク


出演を希望される方は、This email address is being protected from spambots. You need JavaScript enabled to view it.まで、「第34回ライトニングトーク出演希望」という件名で以下の情報を記載したメールをお送りください。

  • お名前 および フリガナ(ハンドル名等で参加される場合はその旨明記ください)
  • 会社名(個人として参加される場合は不要)
  • 連絡先(電話番号)
  • トークのタイトルと概要
  • PC持ち込み あり/なし(接続にはHDMIを使用します)
  • 講演希望場所: 東京 および/または 大阪




May Cool App Winner: Ofertas do Dia

Written by Jim McKeeth on . Posted in Articles

May Cool App Winner: Ofertas do DiaThe cool app Winner for May comes from Brazil. It is Ofertas do Dia, or "Daily Offers" for us English speakers. This cool mobile app runs on iOS, Android and Windows Desktop. It collects all the daily offers from the bigger brazilian online stores and provides them in a clear easy to use app! So every day you can access everything from various sites just in one touch.

Ofertas Do Dia

  • You can share the offers
  • You can share the app
  • You can search offers using words or the barcode scanner
  • You can receive remote push notifications about offers

Besides all the time and internet traffic it saves because it user no longer has to visit every site that publish "daily offers." Some of what else that makes it cool is all the impressive technology it includes. Built on the Enterprise Edition of Delphi using FireMonkey it uses regular expressions to extract products and offers from web pages. The data is stored in a FireDAC TFDMemTable. The display uses a custom ListView appearance. The push notifications are supported through Rafael's own solution that doesn't require a 3rd party push notification provider. 


This cool app is offered by Agile Consultoria de Informática and the developer is Rafael Ribas Aguiló

For Rafael's bio he says "I'm a Delphi developer since its version 1 and love the Delphi productivity." For more information on Ofertas do Dia you can check out the Google Play Store.

To see some of the other cool app entries, or to enter your app, visit the Cool App Competition

Installing InterBase 2017 and XE7 64 bit on Windows 10 Creators U...

Written by Steve A416 on . Posted in Installation / Registration

Customers have reported that it is not possible to install the 64 bit version of InterBase on the Windows 10 Creators Update (build 1703). When you get to the screen that allows you to choose between 32 bit and 64 bit, it is greyed out


A workaround is to perform a silent install, which is described in the documentation at,_Registration,_and_Licensing_Information#Using_the_Wise_Installer_to_Embed_InterBase. A values file for a default installation of InterBase would contain:


MAINDIR=C:\Program Files\Embarcadero\InterBase\




If you have an existing successful installation of InterBase, you will find a values.txt in the program directory.

You would then launch the installer via the following command line:


When the installation has completed, you should find that a 64 bit instance has been installed.

April Cool App Winner: Visuino

Written by Jim McKeeth on . Posted in Articles

Visuino Cool App WinnerI still remember the first time I saw Visuino in action. It was 2 years ago during our Delphi 20th Birthday Party when Boian Mitov unveiled this new project he was building with Delphi. It was really impressive. At the time he wasn't sure what the price would be for it, but looking at the level of utility I expected it to be $500 or more. 

If you are unfamiliar with Visuino, it is a visual IDE for building apps for Arduino and related boards. Instead of writing the code in C, you just connect some visual connectors and Visuino generates the native optimized C code for you. This makes Visuino amazingly productive for rapid component prototyping. It supports a huge variety of chips, boards and components. 

During CodeRage XI Boian had a session showing off Visuino and during the Q&A someone asked the price and he said "Nine, ninety-nine" which I assumed to be $999, which was a lot of money, but Visuino certainly appeared to be worth it. Then he said he wanted to keep it under $10. I was completely blown away that it was that cheap. I didn't have any pressing Arduino projects, but I went out and purchased Visuino anyway. At that price it is a complete no-brainer if you are even moderately interested in Arduino. 


One of the things that is great about Visuino is not only does it make it easy to build Arduino apps, it also makes it easy to connect to those apps from your Delphi apps with Mitov's communication lab. If you are working on an IoT solution, then Visuino is very valuable in component prototyping. 

If you want to see Visuino in action then check out our IoT Boot Camp we did with Visuino. You can also catch the Visuino session from CodeRage XI

Here are some additional resources in working

Visuino has a free mode, just like all Mitov Software's Lab Packs, but at $9.99 I really recommend you just go and purchase a copy. 

RAD Studioロードマップ(2017年5月付)

Written by Hitoshi Fujii on . Posted in News

この記事は、Marco CantuによるRAD Studio Roadmap May 2017の抄訳です。

RAD Studioの現在と将来に関する2017年5月付のロードマップをご覧ください。


RAD Studio / Delphi / C++Builderのアップデートは、製品を購入すると標準で1年間有効なアップデートサブスクリプションサービスによって提供されます。

Build Healthcare Apps with Delphi and FireMonkey (FMX)

Written by Atanas on . Posted in Articles

Today Healthcare is one of the hottest areas for Technology innovation. It is globally a $6B opportunity based on startup funding trends, which is a lot, but there is also a $3 Trillion industry to transform!


Delphi has a particularly strong presence in Healthcare. There are many, many Healthcare systems that are written in Delphi that service literally million of patients and thousands of providers. From primary care EHRs, Dental Software, all kinds of Radiology Suites, the lists goes on, and this is true across the globe. We have multiple existing integrations with some of the largest EHR systems in the World (Mumps integration anyone?).


I believe that there is substantial opportunity to leverage Delphi for Cross-Platform apps in Healthcare. It is an opportunity that is drastically underleveraged. Today, there are very few frameworks that can address this need as well as FireMonkey (FMX) with Delphi. Windows has been a great platform for this with very good security and performance that are critical for healthcare apps. Building HTML5 applications is relatively fast, but disconnected performance is particularly important in Healthcare and security can be stronger with native applications that provide far more encryption options.


The biggest opportunity is for highly functional purpose built applications. Traditional EHRs are very complicated, as they cover many use cases and huge ranges of functionality. However, provider’s time is particularly valuable. Building apps that make providers function more efficiently is super important. Optimizing patient flow to reduce waste is similarly important. These apps do not need to do everything, they need to do some things well. Some of you have probably noticed how providers drag these huge workstations around to type their notes… tablets are lighter, but few UX’s hit the mark. Plenty of room for innovation.

The following example is a nice conceptual view of a Doctor’s office registration application. The use case is super simple, yet think of the last times you’ve been in a doctor’s office and you have see things like this. I have been in some of the largest medical institutions in New York, and guess what - paper everywhere. The only place with an app was an Orthopedist that was charging $500 for a finger splinter that costs $5 at the pharmacy and the insurance covered it, but that is a separate story. Let's build some great apps!


Check out more tips and tricks in this development video: