Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>Hello Experts
> Best Wishes To All. Iam Using DataBase. When Iam creating Tabels All are added in a database. There is Problem Now. When iam creating A temprary Tables in Program Through Sql Query. It Allso Stored in Database. I am Using Those Temproray tabels in a program and when i close the form those temprorary files also deleted. then also those are stored in database.
>
>What iam Want is My Master && Some Important Tables Only stored in database. Remaining free tabels don't stored in database. I think My Problem is clear.
>
>Plz... Help Me How Rective....
Hi Ramakrishna,
If you are going to create temporary tables while working with a database container, you should always put FREE in the create statement of the table, that forces the table not to be put in the container. but like Edward said, you should just make cursors, since they are temporary anyway.
HTH
Beth
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