I've been getting the following error message. 'Missing blob offset in the function TXgetblob'. Is this a schema problem?
Missing Blob Offset
Missing Blob Offset
Some versions of Texis would give this as a warning when retrieving a row that had an empty value put into the blob.
John Turnbull
Thunderstone Software
Thunderstone Software
-
Mr. Bigglesworth
- Posts: 56
- Joined: Fri Feb 16, 2001 6:54 pm
Missing Blob Offset
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?
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?