|
|
|
|
|
|
|
|
|
|
- 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 text memo is retrieved, regardless of its size (Reminder: The SQLGetCol function retrieves only 32 Kb of the string) 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. SQLExec("SELECT NOM, PRENOM, POSTE, NOTES FROM CLIENT", "REQ1")
SQLFetch("REQ1")
SAI_NOM = SQLGetCol("REQ1", 1)
SAI_PRENOM = SQLGetCol("REQ1", 2)
SAI_POSTE = SQLGetCol("REQ1", 3)
SAI_NOTE = SQLGetTextMemo("REQ1", 4)
SQLClose("REQ1")
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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|