Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
USE in SELECT
Message
From
15/12/2020 11:17:26
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
USE in SELECT
Miscellaneous
Thread ID:
01677587
Message ID:
01677587
Views:
98
Hi

I have a strange problem

I use the
USE MyTable IN SELECT('MyTable') 
syntax for a while
On some strange moments
I receive error 3 File is in use

What I see
Prog is in a workarea without open cursor
MyTable is open shared in an other workarea
DATABASE is set correctly, SET DEFAULT points to the path of the database, only one database is open.
A CA that uses this table and might write to it is open

The line is normally running fine, but sometimes it fails.

Any idea why?
I know I can circumvent the very place, but to do this on ever in every place I use IN SELECT(). Ouch
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Next
Reply
Map
View

Click here to load this message in the networking platform