Build a Simple VCL Application for Smaregi Data

How to build a simple VCL Application to view Smaregi data in RAD Studio using the CData FireDAC Components for Smaregi.

Embarcadero RAD Studio provides a development environment for Delphi and C++Builder applications. With the CData FireDAC Components for Smaregi, you gain access to live Smaregi data within RAD Studio, abstracting the data into tables, views, and stored procedures that can be used to both retrieve and update Smaregi data. This article will walk through connecting to Smaregi and creating a simple VCL application with the Form Designer.

Creating a VCL Application for Smaregi Data

The following instructions show how to use the Form Designer to create a simple VCL Forms application that shows the basic FireDAC objects needed to connect to Smaregi from any application.

The following example populates a TDBGrid control.

  1. Create a new VCL Forms Application.
  2. Drop a TFDPhysSmaregiDriverLink and TFDConnection object onto the form.
  3. Double-click the TFDConnection object. The FireDAC Connection Editor is displayed. Select "CData.Smaregi" in the DriverId menu and configure the connection properties.

    スマレジドライバーには、ContractId およびAccessToken パラメータが必要です。

    • スマレジにログイン後、[設定]->[システム連携]->[スマレジAPI 設定]に移動します。
    • [API受信設定]セクションにある[受信機能を利用する]を[利用する]に変更し、[アクセストークンの生成]をクリックし、AccessToken を取得します。
    • 次に必要なAPI アクセスを有効にするため、[機能設定]セクションで必要な機能を[利用する]に変更します。

    ContractId: アカウントの契約ID。これは受信設定セクションでも確認できます。
    AccessToken: 受信設定セクションのアクセストークン。

  4. Drop a TFDQuery object onto the form and set the properties below:

    • Connection - Set this property to the TFDConnection object, if this object is not already specified.
    • SQL - Click the button in the SQL property and enter a query.
    • Active - Set this property to true.
  5. Drop a TDataSource object onto the form and set the following property:

    • DataSet - In the menu for this property, select the name of the TFDQuery object.
  6. Drop a TDBGrid control onto the form and set the following property:

    • DataSource - Select the name of the TDataSource.
  7. Drop a TFDGUIxWaitCursor onto the form. This is required to avoid a run-time error.

You now have an executable application that displays the results of the SQL Query set in the TFDQuery object.

 
 
ダウンロード