could you lock the record after appending blank?
~M
>I have a client that has had intermittent problems with an APPEND BLANK overwriting/reusing a record already on file. I think I have it fixed and I have them testing it, but I wanted to describe what I've done to see if it the fix sounds right.
>
>Right now, in the live system, records are added to XLH.DBF file 2 ways, one form adds them as INSERT INTO XLH (flds) VALUES (Values), and that form has buffering off. Only one record is added at a time. The second way XLH records are added is on another form that adss via APPEND BLANK when the user hits the Add button, and that is also one record at a time. That form has XLH buffering set to pessimistic row.
>
>What has happened about 10 times now is that if the APPEND BLANK happens close to the time of the INSERT in the other form, instead of getting a blank record the user is positioned on the record INSERTED from the other form.
>
>I have installed changes in the test system so that all forms that can add XLH use the same buffering scheme, Pessimistic row, and of course I am having them test by trying to add records at the same time in both forms.
>
>Does this sound like the right approach, or am I missing something?
>
>Thanks
Go raibh maith agat
~M