Creating VCL Applications
The following sections show how to use the Form Designer to create a simple VCL Forms application that shows the basic FireDAC objects needed to connect to Sage 300 from any application. See Writing Data Access Code to work with these FireDAC components from code.
The following example populates a TDBGrid control.
- After Establishing a Connection and creating the TFDPhysSage300DriverLink and TFDConnection objects, 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. This executes the SQL query to Sage 300.
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.
Drop a TDBGrid control onto the form and set the following property:
DataSource Select the name of the TDataSource.
- Drop a TFDGUIxWaitCursor onto the form. This is required to avoid a run-time error.