f2s_lob_get¶

Applies to: Oracle, MS SQL, MySql/MariaDB, PostgreSQL Drivers

Syntax

f2s_lob_get {FileName.FieldName} TO {variable}

Parameter	Description
FileName	The name of the file containing the LOB field
FieldName	The FieldName of the specified LOB field
variable	uChar[] array to hold the LOB value

Description

This command is used for getting the value of a specified LOB field.

Example

     UChar[] uResult
     Integer iID

     Move 1 to iID

     Open PicturesTest
     Clear PicturesTest
     Move iID to PicturesTest.id
     Find Eq PicturesTest by Index.1
     If (Found) Begin
         f2s_lob_get PicturesTest.PictureData to uResult
     End

Related Commands

f2s_lob_set
f2s_lob_set_null
f2s_lob_get_length

Replaces: SQL_GET_LOB, SQL_GET_LOB_CHUNK