I am using VFP 7 with Stonefield Database Dictionary. I do transaction processing but sometimes blank records are created and saved in the database. This causes problems with primary keys. I just wrote a routine to find these blank records and try to reuse them. The pseudo code is something like this: ( optimistic table buffering in place)
select table
set index
seek 0
if found()
scatter memvar blank
gather memvar && make sure all the fields are blank so I can recycle
endif
Later when I try to write to this record with "replace" an error 130 - Record is not locked - is generated. What gives here? How can I fix it? I have given up on trying to prevent blank recs from being generated as it seems to be completely out of my control, but at least I would like to be able to recycle them.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!