|
|
|
|
|
- Retrieving the value of a column
- Transferring the content of the query into a table
- Retrieving Float items on Oracle (via ODBC)
- Using tabulations in the items
SQLAssociate (Function) In french: SQLAssocie Automatically associates each column of the query result with a control or with a variable of the application. After executing the SQLAssociate FUNCTIONfunction, it is necessary to browse the result of the query: fields or variables will then be assigned for each record read. Note This function must be used for "SQLFirst/SQLCol" type runs. For more details on the different modes to loop through a query result, see Types of SQL browse. ResExec is boolean
ResExec = SQLExec("SELECT NOMCLI,ADR1,ADR2,VILLE,CP FROM FACT", "REQ2")
IF ResExec = True THEN
SQLAssociate("REQ2", NomCli, Adr[1], Adr[2], Ville, CodePostal)
SQLFirst("REQ2")
ELSE
END
SQLClose("REQ2")
Syntax
SQLAssociate(<Query name> , <List of operators>)
<Query name>: Character string Name of the query created and executed with SQLExec (the name of the query must be enclosed in quotation marks) or executed with SQLExecWDR (with or without quotation marks). <List of operators>: Character strings, separated by commas List of control names or variable names that will be automatically associated with the corresponding columns of the query (up to 250). These operators are separated by commas. The order of these operators must correspond to the order of the query columns. Remarks Retrieving the value of a column The value of a column can be retrieved individually by SQLCol. Using tabulations in the items The SQL functions are used to insert tabulations into the items of the data files. The management of tabulations depends on the access mode used. Case 1: Executing an ODBC query:When executing a query with ODBC, SQLAssociate does not return tabs. To get the value of the items (with Tabs), use SQLFetch/SQLGetCol. Example: SQLAssociate and the tabulations in the items The items of the records to retrieve are as follows: | | | | Item 1 | Item 2 | Record 1 | John | Smith | Record 2 | John + tab + Mac | Doughnut |
For the first record: - SQLAssociate(Req1, var1, Var2): recovers John and Smith
For the second record: - SQLAssociate(Req1, var1, Var2): retrieves John and Mac, but Mac does not match the value in the second field
- SQLAssociate(Req1, Var1, Var2, Var3): retrieves John, Mac, Doughnut
Case 2: Executing a query using OLEDB, HFSQL or Native Access SQLAssociate automatically retrieves the tabs in the result items.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|