>Hi friends.
>
>I use a datatase for stored procedures. When I'm testing a program often cancels because of any error. Sometimes when I atempt to modify the stored procedures a message appears: "Record is out of range" or so.
>
>I was solving this problem restoring a previous version from a backup. I got a third party program to repare tables but I didn't find one to repare such VFP databases. I haven't lost a big change till now but I could stay a few hours programming a great function or procedure that gets the moon and I won't be very happy if I have to restore a previous backup.
>
>Every time I start one of my programs I "validate" so that's not a solution.
>
>Any idea?
>
>Thank you.
>
> Héctor

I suggest to do the following every time you're about to modify the database

1. PACK DATABASE myDB
2.COMPILE DATABASE myDB

Now it should be OK to modify.