|
File Query |
Scroll |
Some category fields may have custom types which are defined in foreign data base table. A File Query allows you to retrieve this data base table, given the field number of a field with the corresponding custom type.
1 |
Connect to the Thereforeâ„¢ server (see "Server - Connect and Disconnect" for Details) |
2 |
Declare and initialize a new TheQuery. |
3 |
Set a Category and Load it from the server (Comparable to SQL's FROM clause). |
4 |
Select the fields (columns) to be included in the results (Comparable to SQL's SELECT clause). |
5 |
Specify conditions for your query (Comparable to SQL's WHERE clause) |
6 |
|
7 |
7A. Set the FileByFieldNo property to the number of a field of a type defined in a foreign table. or 7B. Set the FileByColName property to the column name of a field of a type defined in a foreign table. |
8 |
Execute the query on the server. |
9 |
Optional. Display the query results in a MessageBox. |
Requirements and Assumptions: If these assumptions do not apply to your system or configuration please replace them with appropriate values when copying the code samples below. |
Category
