Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
USE in SELECT
Message
De
15/12/2020 11:17:26
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
USE in SELECT
Divers
Thread ID:
01677587
Message ID:
01677587
Vues:
96
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]
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform