|
|
|
|
|
|
|
|
|
|
- SQLCol and SQLGetCol functions: different path types
- Current row in the query
- Query without result
- Using tabulations in the items
- Retrieving Float items on Oracle (via ODBC)
- Managing spaces at the end of text items
Retrieves the content of the specified column from the query result, for the current line. Warning This function must be used when browsing the result of a query of type SQLFirst/SQLCol query result.. For more details, see Types of SQL browse. ResExec = SQLExec("SELECT CUSTNAME FROM INVOICE", "QRY1")
IF ResExec = True THEN
SQLFirst("QRY1")
WHILE NOT SQL.Out
ListAdd(LIST_NAME, SQLCol("QRY1", 1))
SQLNext("QRY1")
END
ELSE
END
SQLClose("QRY1")
Sintaxis
<Result> = SQLCol(<Query name> , <Column number>)
<Result>: Character string Value of the column. <Query name>: Character string Name of the query: <Column number>: Integer Number of the column to retrieve. This column corresponds to a query column (and not to a table column). The order of the numbers for the columns to retrieve is not important. Observaciones SQLCol and SQLGetCol functions: different path types SQLCol and SQLGetCol are equivalent during an OLE DB or HFSQL access. However, you must respect the type of browse associated with each one of these functions: - Function SQLCol: "SQLPremier/SQLCol" type path.
- Function SQLGetCol: "SQLFetch/SQLGetCol" type path.
The function SQLCol FUNCTION function must not be called if the query has not returned any results: you must test the variable SQL.Outside variable after positioning yourself in the query result and before calling function SQLCol FUNCTION. For example:
Value is string
QueryText is string
QueryText = "SELECT CUSTNAME, ADDR1, ADDR2, CITY, ZIP FROM INV"
SQLExec(QueryText, "QRY1")
Value = SQLCol("QRY1", 1)
Using tabulations in the items The SQL functions are used to insert tabulations into the file items. The management of tabulations depends on the access mode used. Case 1: Executing an ODBC query: - When executing a query with ODBC, SQLCol does not return tabs. To get the value of the items (with Tabs), use SQLFetch/SQLGetCol.
- When running a query in ODBC, the space characters found at the end of the value of items are removed. To keep all the space characters, we recommend that you 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: - SQLCol(Req1, 1): recovers John
- SQLCol(Req1, 2): recovers Smith
For the second record: - SQLCol(REQ,1 ): recovers John
- SQLCol(REQ, 2): retrieves Mac, but Mac does not match the value in the second field
- SQLCol(REQ, 3): retrieves Doughnut, value of second item
Case 2: Executing a query via OLEDB, HFSQL or Native Connector
SQLCol automatically retrieves the tabs in the result items.
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|