fp file locking behavior

[Bob Stockler]

Bob Haussmann wrote (on Mon, May 21, 2007 at 10:34:37PM -0400):

| Admittedly, this post is a bit of a fishing expedition, but 
| we've exhausted our in-house testing abilities.  Platform is
| Native Windows (ODBC) 5.6.01-5.6.06.
| 
| Occasionally (and unfortunately not in any way that we can consistently
| replicate), we receive file locking errors in fpsql or rclerk on 
| various index files.  These files are in active use, but only in
| add/update mode (*clerk, not *report).  These don't appear to be 
| record locks, but actual file locks.
| 
| The only clue we have at this point is that *clerk appears to open
| the key and active index file for writing, even when simply browsing.
| I would appreciate it if anyone else can confirm this behavior so
| we can be sure it isn't specific to our setup (XP clients w/ Novell
| client32 4.9* and Netware 6.5 server):
| 
| 1) using any filepro database, take note of the "last modified" timestamp
| of your key and index.A file.
| 2) start rclerk, select this database
| 3) choose "index selection" and a specific index
| 4) put any search criteria and start search
| 5) re-check the timestamp on the index file that was just used.
| 
| In theory, the timestamp in #1 and #5 should be the same, since this
| was a read-only query.  In fact, if we take a copy of the file before this
| process, and compare it byte for byte against the one modified in step 5,
| there are no differences. 
| 
| Can anyone else verify this behavior on a different platform?

Accessing a filePro file using [dr]clerk via an index, has always
(at least, so far as I remember) caused the date-time stamp on that
index to be modified, whether or not any records were added or
edited, or, for that matter, even entered in Update Mode.

I just verified it using filePro 5.6.06 on SCO OSR6.  The date-time
stamp appeared to represent the time I entered the file, where I
simply sat at the IUA prompt on the first record for a minute or so.

Bob

-- 
Bob Stockler +-+ bob at trebor.iglou.com +-+ http://members.iglou.com/trebor