FbCommand component

Drag the FbCommand Component

1. Choose fbCommand1 in the Form Designer.

2. In the Properties Window choose a FbConnection.

3. Click the "..." next to CommandText property. CommandText Editor will appear.

4. Type your SQL command and press "Execute" to test it. If everything works you can see the results below.

5. You can also look at the Firebird execution plan by clicking "Plan" tab.

6. If there is a problem with the SQL statement you will see the error message under "Error" tab.

7. If your SQL command contains parameters enter them in the SQL command with a starting "@".

8. Define the parameters in the FbParameter Collection Editor (click "..." next to Parameters property in the Properties Window).