f2s_lob_set¶

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

Syntax

f2s_lob_set {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 set the LOB value

Description

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

Example
     UChar[] uResult
     Integer iID iLength iSize
     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_length PicturesTest.PictureData to iLength
         f2s_lob_get PicturesTest.PictureData to uResult
         If (iLength > 0 ) Begin
             Clear PicturesTest
             Move "TestBaK" to PicturesTest.PictureName
             f2s_lob_set PicturesTest.PictureData to uResult
             SaveRecord PicturesTest
         End
     End

Related Commands

Replaces: SQL_SET_LOB, SQL_ADD_LOB_CHUNK