|
- Current line in the query
- Query columns
- Query without result
- Using tabulations in the items
- SQLCol and SQLGetCol functions
- Retrieving Float items on Oracle (via ODBC)
SQLGetCol (Function) In french: SQLLitCol
i is int = 0
SQLExec("SELECT LASTNAME, FIRSTNAME, EXTENSION, PHOTO FROM CUSTOMER", "QRY1")
// Retrieve the query line by line
WHILE SQLFetch("QRY1") = 0 // There is another line to read
i++
// Retrieve the data
LASTNAME[i] = SQLGetCol("QRY1", 1)
FIRSTNAME[i] = SQLGetCol("QRY1", 2)
EXTENSION[i] = SQLGetCol("QRY1", 3)
END
SQLClose("QRY1")
Syntax
<Result> = SQLGetCol(<Query name> , <Column number>)
<Result>: Character string Value of the column. <Query name>: Character string (with or without quotes) Name of query created and run by SQLExec (with quotes) or run by SQLExecWDR (with or without quotes). Versions 16 and later New in version 16 <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 subscript of the columns must be specified in ascending order. For example, you must do SQLCol("QRY1", 1) then SQLCol("QRY1", 2).
Remarks Current line in the query The current line is positioned by SQLFetch. - To read the memo columns, use SQLGetMemo. To read the Text Memo columns, use SQLGetTextMemo.
 SQLGetMemo and SQLGetTextMemo are useless.
Versions 16 and later The memo columns cannot be read. New in version 16 The memo columns cannot be read. 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 into a character string. However, the WLanguage allows you to assign the result returned by SQLGetCol into a numeric variable. The conversion is automatically performed by the WLanguage.
- The columns must necessarily be retrieved in order of ascending number.
 The columns can be retrieved in any order. - The same column cannot be retrieved several times in a row. Indeed, the second time, the result will be an empty string.
Versions 16 and later The same column can be retrieved several times in a row. New in version 16 The same column can be retrieved several times in a row. The same column can be retrieved several times in a row. - SQLGetCol cannot be used to retrieve the binary strings.
SQLGetCol must not be called if the query returned no result: the test of the SQL.Out variable must be run when you are positioned in the query result and before you call SQLGetCol. For example:
// Retrieve the value of the 1st column for the 1st record
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 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: - SQLGetCol(QRY, 1): retrieves John
- SQLGetCol(QRY, 2): retrieves Smith
For the second record: - SQLGetCol(QRY,1 ): retrieves John + tab + Mac
- SQLGetCol(QRY, 2): retrieves Doughnut
This page is also available for…
|
|
|
| |
| Click [Add] to post a comment |
|
| |
|
| |
| |
| |
| |
| |
| |
| | |
| |