Icon Seek Method

function Seek(Offset: Integer; Origin: Word): Integer

function Seek(const Offset: Int64; Origin: TSeekOrigin): Int64

Use Seek to move the current position within the BLOB or CLOB column by the indicated offset. Seek allows an application to read from or write to a particular location within the BLOB or CLOB column.

The Origin parameter indicates how to interpret the Offset parameter. Origin should be one of the following values:

OriginDescription
soFromBeginningOffset is from the beginning of the BLOB or CLOB column. Seek moves to the position Offset. Offset must be >= 0.
soFromCurrentOffset is from the current position in the BLOB or CLOB column. Seek moves to Position + Offset.
soFromEndOffset is from the end of the BLOB or CLOB column. Offset must be <= 0 to indicate a number of bytes before the end of the BLOB or CLOB.

Seek returns the new value of the Position property, the new current position in the BLOB or CLOB column.

Information Please remember that if you are using a stream on a CLOB column, then the number of characters in the CLOB column will not be equal to the number of bytes in the stream.
Image