SQLGetMemo (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

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
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 row.

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.

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

Example

SQLExec("SELECT NOM, PRENOM, POSTE, PHOTO FROM CLIENT", "REQ1")
SQLFetch("REQ1") // Ou SQLFetch("REQ1")
// Récupérer les données
NOM = SQLGetCol("REQ1", 1)
PRENOM = SQLGetCol("REQ1", 2)
POSTE = SQLGetCol("REQ1", 3)
// Lire le mémo binaire et le stocker dans un fichier
// Photo du produit
HExtractMemo(SQLGetMemo("REQ1", 4), "Produit.BMP")
SQLClose("REQ1")
// Récupération d'un mémo binaire
SQLExec("SELECT NOM, MORCEAU FROM MUSIQUE", "REQ1")
// Joue le mémo binaire
Sound(SQLGetMemo("REQ1", 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: wd300hf.dll