Retrieves the content of a Text Memo column found in the query result, for the current line. The entire content of text memo is retrieved, regardless of its size (Reminder:
SQLGetCol only retrieves 32 KB from the character string)
Caution: This function must be used during a "SQLFetch/SQLGetCol" browse of the query result. For more details, see
Types of SQL browse.
SQLExec("SELECT LASTNAME, FIRSTNAME, EXTENSION, NOTES FROM CUSTOMER", "QRY1")
SQLFetch("QRY1")
// Retrieve the data
EDT_LASTNAME = SQLGetCol("QRY1", 1)
EDT_FIRSTNAME = SQLGetCol("QRY1", 2)
EDT_EXTENSION = SQLGetCol("QRY1", 3)
// Read the text memo
EDT_NOTE = SQLGetTextMemo("QRY1", 4)
SQLClose("QRY1")
Syntax
<Result> = SQLGetTextMemo(<Query name> , <Column number>)
<Result>: Character string
Text memo.
<Query name>: Character string
Name of the query created and executed with SQLExec (in quotation marks), or executed with SQLExecWDR (with or without quotation marks).
<Column number>: Integer
Number of the text memo column to retrieve. This column corresponds to a query column (and not to a table column).