Is this repairable

MiniMe · Post by **MiniMe** » Wed Mar 06, 2002 5:31 pm

When trying to do an update I get these errors. Are they repairable.

05 Bad size 0 for column USER_REC at offset 0xC0 in recid 0x0 of /db/tables/prod/books.tbl in the function fbuftofld
100 Error in data, file /db/tables/prod/books.tbl, offset 0x0
005 Bad size 0 for column USER_REC at offset 0xC0 in recid 0x0 of /db/tables/prod/books.tbl in the function fbuftofld
100 Error in data, file /db/tables/prod/books.tbl, offset 0x0
005 Bad size 0 for column USER_REC at offset 0xC0 in recid 0x0 of /db/tables/prod/books.tbl in the function fbuftofld
100 Error in data, file /db/tables/prod/books.tbl, offset 0x0

Post by **John** » Wed Mar 06, 2002 6:15 pm

That suggests somehow you have a bad index on the field in your where clause, which is pointing to an invalid location in the table. If you rebuild that index you should be OK.

MiniMe · Post by **MiniMe** » Wed Mar 06, 2002 6:16 pm

Hmm... my where clause consistst of "where PRICE = '0'" yet it says USER_REC. Should I do both columns?

Post by **John** » Wed Mar 06, 2002 6:18 pm

No, just the PRICE one. The block of data the index pointed to looked invalid, which is where USER_REC came in.