>This is a bizarre situation.
>I have a table which has several index tags. I set order to certain to one index tag, use seek to find out if the record, if not found, than use SQL insert command insert a record. After table updated, I fail to see the record neither by using browse command nor SQL select statement. However, if I reindex the table, the inserted record appeared. I can see the record either by using browse command or SQL select statement
>Is anybody can give a clue?
Is the table on a server? If so, the writes are probably being cached by the drive controller. This makes the table suspectable to corruption. Turn off the write cache on the server's driver controller.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer