|
|
|
|
- Current row in the query
- Query columns
SQLGetTextMemo (Function) In french: SQLLitMémoTexte 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).
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|