- Current row in the query
- Query columns
- Using a binary memo
SQLGetMemo (Function) In french: SQLLitMémo 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.
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
// Product image
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 SQLFetch sets the position on the current row. To read columns other than Memo columns, use SQLGetCol. 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.
This page is also available for…
|
|
|
|