Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Doug,
Thanks for the reply. This worked very will with a minor correction to your syntax:
OPEN DATABASE MyDatabase EXCLUSIVE
instead of
USE MyDatabase EXCLUSIVE
I found that I have many references to temp tables in my DBC that I didn't expect find. When I programatically CREATE TABLE, it seems the table is added into the currently open DBC. Then when I delete the table at the end of my function, the reference still remains in the DBC. Do I need to issue a DROP TABLE before I delete the table? This will make my DBC grow with deleted records. Is there any way to create a table without adding a record to the DBC?
Thanks,
John
Précédent
Suivant
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