SQLGetTextMemo (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Current line in the query
Query columns

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLGetTextMemo (Function)

In french: SQLLitMémoTexte

Retrieves the content of a Text Memo column found in the query result, for the current line. The entire content of text memo is retrieved, regardless of its size (Reminder: SQLGetCol only retrieves 32 KB from the character string)

Caution: This function must be used during a "SQLFetch/SQLGetCol" browse of the query result. See Types of SQL browse for more details.

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, NOTES FROM CUSTOMER", "QRY1")
SQLFetch("QRY1")
// Retrieve the data
EDT_LASTNAME = SQLGetCol("QRY1", 1)
EDT_FIRSTNAME = SQLGetCol("QRY1", 2)
EDT_EXTENSION = SQLGetCol("QRY1", 3)
// Read the text memo
EDT_NOTE = SQLGetTextMemo("QRY1", 4)
SQLClose("QRY1")

Syntax

<Result> = SQLGetTextMemo(<Query Name> , <Column Number>)

<Result>: Character string

Text 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).
The queries created in the query editor must be specified in the format of a character string with quotes.

<Column Number>: Integer

Number of the text 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.

To read other types of memo columns, use SQLGetMemo.

Component : wd250hf.dll