Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understanding Cursors
Message
De
25/09/1999 21:34:57
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00268989
Message ID:
00269018
Vues:
34
>>
>>CLOSE DATA will close your cursors and tables. Stopping the web server is not a FoxPro problem, but is due to running the DLL in IIS. Run the DLL in MTS and then you only have to shutdown the package running the DLL.
>
>Hi Craig,
>
>I could be wrong but I thought CLOSE DATA was short for CLOSE DATABASE and that won't close the cursors will it? It only closes the tables in the open current database. Tadd would have to use CLOSE TABLES ALL to close the cursors. Although the cursors being open should not cause the exclusive problem.
>
>Tadd, do you have more than 1 database? If so, you might only be closing the current one, try CLOSE DATABASE ALL, that would close all open databases. Also so you know, SQL SELECT statements cause VFP to open any involved tables (behind the scenes so to speak) so you might be leaving something open and not relizing it. You may also want to look at the CLOSE ALL command, it closes everthing.
>
>hth

Thanks Roi,

I had meant to say CLOSE DATA ALL which will close all tables, cursors, and database containers.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform