-p on LOOKUPs - further clarification?
Kenneth Brody
kenbrody at bestweb.net
Fri Jun 15 13:10:09 PDT 2007
Quoting Jay R. Ashworth (Fri, 15 Jun 2007 14:42:12 -0400):
[...]
> So, when you say -p, filePro write locks the target record (and
> associated index records) *while it is writing that data item* -- and
> unlocks it automagically afterwards?
[...]
A "lookup -p" time:
The lookup is performed, and the record is located.
The record is locked.
The record is read.
... The record is used by processing. ...
When it's time to write/unlock the record[*]:
The record is written.
The record is unlocked.
[*] Lookup records are written:
At an explicit WRITE.
At an explicit CLOSE.
A GETNEXT/GETPREV is executed.
The LOOKUP itself is re-executed.
When processing ends. Note that field-level events (such as
@WLF/@WEF) ending do not constitute "processing ending".
(This list is from memory, so it may be incomplete.)
--
KenBrody at BestWeb dot net spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com
More information about the Filepro-list
mailing list