PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Current line in the query
  • Query columns
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
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. See Types of SQL browse for more details.
PHP This function is useless in PHP. It is equivalent to SQLGetCol.
Versions 19 and later
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
New in version 19
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
Android Widget This function is now available in Android Widget mode (accessing the external databases via a Webservice).
Android This function is now available for the Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for the iPhone/iPad applications (accessing the external databases via a Webservice).
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
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 (with or without quotes)
Name of query created and run by SQLExec (with quotes), or run by SQLExecWDR (with or without quotes).
Java The queries created in the query editor must be specified in the format of a character string with quotes.
<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
WINDEVWEBDEV - Server codeReports and QueriesJavaPHPAjaxUser code (UMC)

Current line in the query

The current line is positioned by SQLFetch.
WINDEVWEBDEV - Server codeReports and QueriesJavaPHPAjaxUser code (UMC)

Query columns

To read columns other than Memo columns, use SQLGetCol.
To read other types of memo columns, use SQLGetMemo.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment