Specify that you want to create a select query "Select" option. The query can be run in the program by HExecuteQuery.
The wizard for query creation starts. In the window that is displayed, click "Queries". And remember, you become an other developer to your own source code after a few weeks of not looking at it!!!
Example 6 For example, consider a simple PHP script that will print out the vendor id, vendor name, and vendor state for each vendor in the Vendors table. To do so, you must: Create a Data Source variable to represent the query at run time.
To include an item, click its name in the list on the left: Validate. The code can be directly typed in the SQL code area. In this example, we are going to calculate the value of an order line according to a unit price, the quantity ordered and a discount.