|
|
|
|
|
|
|
|
|
|
- Current row in the query
- Query columns
- Query without result
- Using tabulations in the items
- SQLCol and SQLGetCol functions
- Retrieving Float items on Oracle (via ODBC)
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 "SQLFetch/SQLGetCol". For more details, see Types of SQL browse. i is int = 0
SQLExec("SELECT LASTNAME, FIRSTNAME, EXTENSION, PHOTO FROM CUSTOMER", "QRY1")
WHILE SQLFetch("QRY1") = 0
i++
LASTNAME[i] = SQLGetCol("QRY1", 1)
FIRSTNAME[i] = SQLGetCol("QRY1", 2)
EXTENSION[i] = SQLGetCol("QRY1", 3)
END
SQLClose("QRY1")
Sintaxis
<Result> = SQLGetCol(<Query name> , <Column number>)
<Result>: Character string Value of the column. <Query name>: Character string Name of the query created and executed with SQLExec, or executed with SQLExecWDR. <Column number>: Integer Number of the column to retrieve. This column corresponds to a query column (and not to a table column). If several columns must be retrieved, the index of the columns must be specified in ascending order. For example, you must do SQLCol("QRY1", 1) then SQLCol("QRY1", 2).
Observaciones The current line is positioned by SQLFetch. - To read memo columns, use SQLGetMemo. To read the text memo columns, use SQLGetTextMemo.
 SQLGetMemo and SQLGetTextMemo are useless.
 The memo columns cannot be read. - The number of columns found in the query result is returned by the SQL.NbCol variable (assigned by SQLInfo).
- If the column is a numeric column, SQLGetCol converts the result to a string. However, in WLanguage, you can assign the result returned by SQLGetCol in a numeric variable. WLanguage automatically performs the conversion.
- Columns have to be retrieved in ascending order.
 Columns can be retrieved in any order. - The same column cannot be retrieved several times in a row. The second time it is retrieved, the result is an empty string.
The same column can be retrieved several times in a row. - SQLGetCol doesn't get binary strings.
The function SQLGetCol FUNCTION function must not be called if the query has not returned any results: you must test the SQL.Outside variable after positioning yourself in the query result and before calling the SQLGetCol FUNCTION. For example:
Value is string
QueryText is string
QueryText = "SELECT CUSTNAME, ADDR1, ADDR2, CITY, ZIP FROM INV"
SQLExec(QueryText, "QRY1")
Value = SQLGetCol("QRY1", 1)
Using tabulations in the items The SQL functions are used to insert tabulations into the file items. Example: SQLGetCol and tabs in 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: - SQLGetCol(REQ, 1): retrieves John
- SQLGetCol(REQ, 2): retrieves Smith
For the second record: - SQLGetCol(REQ,1 ): retrieves John + tab + Mac
- SQLGetCol(REQ, 2): retrieves Doughnut
Esta página también está disponible para…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|