column size

[sourceuno]

I tried performing some updates on a table and I get the following errors:

Truncated data for column Url in recid 0x000000000000000 of (temp RAM DBF) in function pbuftofld

Bad size 46 for column Url before offset 0x1 in recid 0x000000000000000 of (temp RAM DBF) in function pbuftofld

I then noticed that some of the field lengths for the Url are longer than the length I specified for the Url column which is a varchar(80). Is the database supposed to store data that is longer than the defined field length?

Also does the fact that I have records with fields longer than the defined length effect what is stored in the index if that particular field is indexed? Would this account for some records not showing up in a search?

[John]

That suggests a problem with the index on the Url column, and that it should be dropped and rebuilt. The database will store data that is longer than the defined field lenght, and that should not be a problem. Text fields over 2K could cause the index problems, although that should be reported when inserted.