今すぐお試しください!

製品の詳細CData FireDAC Components for e-Sales Manager Remix を確認して、無償評価版をダウンロード:

今すぐダウンロード

Build a Simple VCL Application for e-Sales Manager Data

How to build a simple VCL Application to view e-Sales Manager data in RAD Studio using the CData FireDAC Components for e-Sales Manager.

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

Creating a VCL Application for e-Sales Manager 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 e-Sales Manager from any application.

The following example populates a TDBGrid control.

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

    e セールスマネージャー Remix に接続するには、User、Passowrd、URL、TenantId パラメータが必要です。

    • User: API を実行するためのログインユーザーのユーザーID。
    • Password: API を実行するためのログインユーザーのユーザーパスワード
    • URL: e-Sales Manager Remix エンドポイントへのURL。例:https://XXX.softbrain.co.jp
    • TenantId: e-Sales Manager Remix テナント名のTenantd。例:cdata

  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.

 
 
ダウンロード