Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
When does the table used in SQL SELECT close?
Message
De
20/12/2001 12:05:25
Alexandre Palma
Harms Software, Inc.
Alverca, Portugal
 
 
À
20/12/2001 11:57:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00596837
Message ID:
00596843
Vues:
35
hi your table will beclose when you issue a close data all or close all
About your question the answer is yes you should close the table if you don't need it this is also applicable to the cursor.

>When using a SQL statement, does the database and/or the table need to be explicitly opened first (USE myTable, OPEN myDatabase ?), or does the SQL SELECT statement automatically opens up myTable?
>Another question:
>After a SQL SELECT statement, when does the table close?
>Example: SELECT * FROM myTable INTO CURSOR xTemp
>myTable automatically opens?
>When does myTable close: do I need to specifically close it:
>SELECT myTable
>USE
>... what is a good practice: after SQL SELECT statement, manually close myTable & use xTemp cursor??
Alexandre Palma
Senior Application Architect
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform