>after I deleted the tag and browse give me the same error.
>sherry
Is it a free table or part of database? If you can not browse it (even in command window), then I guess, you have a serious data corruption :(((((
Does this table have a memo field? You can find, if it has NULLs, by browsing, but since you can't BROWSE, it's hard to tell.
Try this test: Create a table with the exact same structure as the 'corrupted' table
Test1
use NewTable alias NewTable in 0
use tableInQuestion alias Corrupted in 0
select Corrupted
scan
scatter memvar memo
select NewTable
gather memvar memo
endscan
If you will be able to run this test without errors, you'll have a new table with the same data as in the old one. See, if you can Browse it.
Another shot in the dark: perhaps you somehow changed collate settings, while created this table, so now everything is screwed up...
If it's not broken, fix it until it is.
My Blog