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

f2s_lob_get
f2s_lob_set_null
f2s_lob_get_length

Replaces: SQL_SET_LOB, SQL_ADD_LOB_CHUNK