ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / SQL functions
  • Current row in the query
  • Query columns
  • Using a binary memo
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 Memo column from the query result, for the current row.
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, PHOTO FROM CUSTOMER", "QRY1")
SQLFetch("QRY1")
// Retrieve the data
LASTNAME = SQLGetCol("QRY1", 1)
FIRSTNAME = SQLGetCol("QRY1", 2)
EXTENSION = SQLGetCol("QRY1", 3)
// Read the binary memo and store it in a file
// Product image
HExtractMemo(SQLGetMemo("QRY1", 4), "Product.BMP")
SQLClose("QRY1")
// Retrieve a binary memo
SQLExec("SELECT NAME, PIECE FROM MUSIC", "QRY1")
// Plays the binary memo
Sound(SQLGetMemo("QRY1", 2))
Syntax
<Result> = SQLGetMemo(<Query name> , <Column number>)
<Result>: Character string
Binary memo.
<Query name>: Character string
Name of the query created and executed with SQLExec, or executed with SQLExecWDR.
<Column number>: Integer
Number of the memo column to retrieve. This column corresponds to a query column (and not to a table column).
Remarks

Current row in the query

SQLFetch sets the position on the current row.

Query columns

To read columns other than Memo columns, use SQLGetCol.

Using a binary memo

The binary memo read by SQLGetMemo can be:
  • Played by Sound if the binary memo is a .WAV file.
  • Displayed in an Image control if the binary memo is in BMP format.
  • Stored in a file by HExtractMemo.
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