Hi!

Sometimes I had some problems with DBF files...
After a crash or something like that, DBF files do not return any error, but I can't add records using INSERT-SQL command.

For example, if I execute the command in a "special crash DBF"...

Insert Into MyTable (Field1, Field2, FieldN) Values (1,"test",date())

... VFP do not return any error, but the new record is not added.

So, to solve it, I have to do it:

USE MyTable Excl
Browse
Press CTRL+Y (Add Record)
Press CTRL+T (Delete this new record)
PACK

After it, if I repeat the command Insert, the new record is added correctly.

Someone knows when this problem appears, and how to prevent it?
Because the major problem is sometimes the user do not percept it and add a lot of data for nothing.... :'(

[]s