>I am using record locking when I edit records. Do I need to lock the file when I append a blank record? How about if I change the code to do a SQL Insert?
>
>According to the VFP docs, "FLOCK( ) returns true (.T.) if the table is successfully locked and returns false (.F.) if the table or a record in the table is already locked by another user." So, since I have other users with records locked for editing, I will not be able to lock the file to append a blank record.
I think FoxPRo will attempt to take the table exclusive when an append blank is done. So lets say another user has the table open and is editing a record (no buffering). When an append blank is done on the table by another user, then in my opinion (I could be wrong) that VFP will error out that the file is in use (by the one who is editing).
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope