General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only