Table closed but 'file is in use' ... ? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Table closed but 'file is in use' ... ?

Message

De

12/03/2001 14:48:05

Dan Goodwin
Primary Data Solutions
Springfield, Virginie, États-Unis

À

12/03/2001 14:41:25

Fausto Garcia
Independent Developer
Lima, Pérou

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: Table closed but 'file is in use' ... ?

Divers

Thread ID:

00484196

Message ID:

00484199

Vues:

14

>What might the problem be here?

SQL will open the source table filtered instead of creating a new cursor if it can.

Check the DBF() of the cursor and I bet it's your table. Add NOFILTER to the SQL statement to prevent SQL from doing this.

Dan Goodwin
Primary Data Solutions

Click here to load this message in the networking platform