f2s_lob_get_length¶

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

Syntax

f2s_lob_get_length {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	The variable to hold the length of the field

Description

This command is used to get the length of a specified LOB field.

Example

         UChar[] uResult
         Integer iID iLength
         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
             Showln "The Length of PictureData:" iLength
         End
         inkey WindowIndex

Related Commands

f2s_lob_set
f2s_lob_get
f2s_lob_set_null

Replaces: SQL_GET_LOB_LENGTH