f2s_lob_set_null¶

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

Syntax

f2s_lob_set_null {FileName.FieldName}

Parameter	Description
FileName	The name of the file containing the LOB field
FieldName	The FieldName of the specified LOB field

Description

This command is used to set a LOB column to null.

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
             Reread PicturesTest
             f2s_lob_set_null PicturesTest.PictureData
             SaveRecord PicturesTest
             Unlock
     End

Related Commands

f2s_lob_set
f2s_lob_get
f2s_lob_get_length

Replaces: SQL_LOB_TRUNCATE