PC SOFT

ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Home | Sign in | English EN
  • 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.
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 Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for 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 Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for 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 Android applications (accessing the external databases via a Webservice).
iPhone/iPad This function is now available for 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, 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
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: wd270hf.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment