ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / SQL functions
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
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.
Example
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).
Remarks
Component: wd290hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 05/26/2022

Send a report | Local help