Page 1 of 1
Missing Blob Offset
Posted: Sat Jun 16, 2001 1:27 pm
by hackchief
I've been getting the following error message. 'Missing blob offset in the function TXgetblob'. Is this a schema problem?
Missing Blob Offset
Posted: Sun Jun 17, 2001 12:16 pm
by John
Some versions of Texis would give this as a warning when retrieving a row that had an empty value put into the blob.
Missing Blob Offset
Posted: Mon Jun 18, 2001 1:54 pm
by Mr. Bigglesworth
I believe we're getting this problem in the following way:
When we do an insert statement into a table with a blob field, and we don't reference the blob field, strange things happen, ie:
insert into mytable (NONBLOB1, NONBLOB2) values ('hello','there')
When I do a select afterwards, I actually get values appearing in my BLOB field, even though I never inserted any values into it! It's like it's pulling stuff from another record.
So I guess the question is: can we insert records into a BLOB-ed database without having to actually reference the blob field itself?