>Hi,
>
>I have a table that has corrupt data in several of the fields. I'm sure this corruption is caused by my program because it reappears after repair within a few weeks. When I browse the table the corrupt data appears as vertical blocks in the field. Since as I can't find where the code is corrupting the data I thought it might be helpful to determine what the corrupt looked like but so far I have not been able to read the corrupt data. Does anyone know of a function or something that might provide a way of reading this corrupt data? So far I think the fields contain zero's (0) but I doubt that a vertical black block would be displayed if the data was just a binary 0. From the command box a left(myitem,1) will display a rectangle.
>
>TIA
>John
John,
for ix=1 to len(myItem)
? asc(substr(myItem,m.ix))
endfor
PS:If your primary key is integer do not make it the first field (ie: put a dummy c(1) field before it).
Cetin