Error in select statement on BLOB field

Post Reply
Mr. Bigglesworth
Posts: 56
Joined: Fri Feb 16, 2001 6:54 pm

Error in select statement on BLOB field

Post by Mr. Bigglesworth »

When we run the following query:

tsql "select DOCID from tbldoc1 where OCR = 'None'"

on one of our tables, we get a series of error messages, like so:

100 Error in data, file F:\database\dow\tbldoc1.tbl, offset 0x8B8EA1


However, this query:

tsql "select DOCID from tbldoc1 where OCR like 'None*'"

returns results with no problem. We're using the NT version of texis, Nov. 1999 version, and none of our file sizes are above 2 GB, which can be a problem in NT. Do you know why we're getting that error message at first, and how we might get rid of it?
User avatar
John
Site Admin
Posts: 2622
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

Error in select statement on BLOB field

Post by John »

That suggests that there are some errors in some of the records in that table. With the '=' query you probably don't have an index, so every record is being looked at, and with the like you are using an index, which is pointing directly to specific records.

Depending on what is easiest you would want to consider either repairing the table with the aid of kdbfchk, or it maybe simpler to recreate the table.
John Turnbull
Thunderstone Software
Post Reply