PC SOFT

WINDEVWEBDEV AND WINDEV MOBILE
ONLINE HELP

Home | Sign in | English UK
  • Current line 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/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Retrieves the content of a Memo column from the query result, for the current line.
Caution: This function must be used during a "SQLFetch/SQLGetCol" browse of the query result. See Types of SQL browse for more details.
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
// Photo of product
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 (with or without quotes)
Name of query created and run by SQLExec (with quotes), or run by SQLExecWDR (with or without quotes).
<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 line in the query

The current line is positioned by SQLFetch.

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 : wd250hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment