>Hello, i'm having this problem since a few months and its about a table i used in two differents forms and when you save a record in this table, sometimes it duplicates the record and when you try to made some operations with the table the application doesn't work, i have to shutdown the application.
>
>I can do this with triggers or exists a better way in order to validate if the record exists previous saving it?.
>Can you help me with some examples?
>
>Thanks for the help.
It may be known problem in VFP5, VFP6 ( no service pack buf 3, index on char field, two users edit same record
Index is destroed and fake tween records are visible
I forced MS ro fix it, it was fixed in sp4
If so, use buf=5, or view
Vladimir

MVP-2006-2011, PHD in Math and Physics ,
host of www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.