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:
Origin
Description
soFromBeginning
Offset is from the beginning of the BLOB or CLOB column. Seek moves to the position Offset. Offset must be >= 0.
soFromCurrent
Offset is from the current position in the BLOB or CLOB column. Seek moves to Position + Offset.
soFromEnd
Offset 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.
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.