Writes a string into a LOB
This function can be used to write a string into a portion (or all) of a LOB field.
A LOB/FILE locator that uniquely references the LOB/FILE. This locator can be obtained calling the Fetch method with third parameter to true.
The string to write into the LOB field
It is the absolute offset from the beginning of the LOB value. For character LOBs it is the number of characters from the beginning of the LOB, for binary LOBs it is the number of bytes. The first position is 1.
query = "select MYBLOB from MYTABLE where ID=" + id + " FOR UPDATE"
cursID = mydb.Exec(query)
lobLocator = mydb.FetchRec(,,true)