ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / Managing databases / SQL functions
  • Current row in the query
  • Query columns
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
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.
Example
SQLExec("SELECT NOM, PRENOM, POSTE, NOTES FROM CLIENT", "REQ1")
SQLFetch("REQ1") // Ou SQLFetch("REQ1")
// Récupérer les données
SAI_NOM = SQLGetCol("REQ1", 1)
SAI_PRENOM = SQLGetCol("REQ1", 2)
SAI_POSTE = SQLGetCol("REQ1", 3)
// Lire le mémo texte
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).
Java The queries created in the query editor must be specified in the format of a character string.
<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
WINDEVJavaUser code (UMC)

Current row in the query

SQLFetch sets the position on the current row.
WINDEVJavaUser code (UMC)

Query columns

To read columns other than Memo columns, use SQLGetCol.
To read other types of memo columns, use SQLGetMemo.
Component: wd300hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help