SQLGetMemo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Current line in the query
Query columns
Using a binary memo

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLGetMemo (Function)

In french: SQLLitMémo

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.

This function is useless in PHP. It is equivalent to SQLGetCol.

Versions 19 and later

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

New in version 19

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

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 (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: wd260hf.dll