Table and Record Locking Problem

[buddyrich2]

I have a (web based) application that opens and closes foxpro tables. I am not using the tables inside databases - just using free tables. More and more often (as traffic increases) I am getting file and record locking errors ("table is in use by another...").

Would it help if I had them inside databases, then opened the database to get to the tables?

Any other suggestions?

Thanks!

 

[DSummZZZ]

Using a database wouldn't make a difference. It's more of a sharing issue. Are you by chance trying to open them exclusive?

Make sure to either SET EXCLUSIVE OFF, or USE SomeTable SHARED.

Make sure you aren't using commands which require a lock of the table header, such as REPLACE ALL.

Also, make sure to UNLOCK the records after updating them.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[dgrewe]

Also all ways make sure you close the table in the procedure you opened it in. Never leave a table open when the page is set.

David W. Grewe Dave