View Complete Thread | FoxWeb Forum Home
Search:
Date:    Msg ID:   
From:    Thread:   
Subject:   
Thanks. The next time it happens I will take a look. I think I did before but cannot remember - must not have made an impression at the time. The data options from the tools menu are set correctly. I'll just have to wait and see. Thanks for the reply.
Joe
Sent by FoxWeb Support on 02/06/2007 10:26:21 AM:
The Tables and Environment tabs in the FoxWeb Error Log should be able to tell you the status of EXCLUSIVE and REPROCESS while the error occurred.
FoxWeb Support Team
support@foxweb.com email
Sent by James Williams on 02/06/2007 05:56:28 AM:
Do you create any temp tables on disk in the script that is causing the problem?
Sent by Joe Goldsmith on 01/10/2007 12:09:04 AM:
No takers on the problem?
Joe
Sent by Joe Goldsmith on 12/23/2006 06:17:19 PM:
Hi all. Every once in a while I find an error in the FoxWeb error log that a file is already open by another user. I can't understnd why this is so. The project's options under the data tab is
unchecked for Open exclusive
Automatic file locking is unchecked
multiple record locks is checked
Buffering is record optimistic
reprocessing is set to Attempt lock
All data fetches, updates, and adds are done through SQL commands.  Most Select statements use one or more QueryString parameters.
The most recent error where the file is already open by another is a Select to our inventory table using the Full-Text Search Engine. Would anyone have an idea show this occured and perhaps how to eliminate it?
Joe