Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Sweet!
>>Is there a way from keeping a SQL Select statement from leaving the tables open that is pulls from?
>>
>>I'm annoyed that if the tables are not already opem, it will open them (which is fine), but it leaves the tables open (i.e. USED).
>>
>>I wish it would close them back. Right now, I am doing a USE IN statement on about 4 tables to close them due to having been opended by a SQL Select statement.
>
>Check Class to close any cursors created after it was instantiated FAQ #31943
>
>So, you would instantiate this class before the select, then release it.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement