Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

SQL temp tables

Hi all..........
I'm using Delphi3, BDE and Pardox.
When i execute a SQL some temp tables are created in the current folder but they are not deleted after the SQL is done.
Is there any way i can tell the BDE or the Query component in which folder to create the temp tables ???
0
dotan
Asked:
dotan
  • 2
1 Solution
 
vladikaCommented:
Try to use
TSession.PrivateDir

0
 
vladikaCommented:
I mean you may use component TSession and set property PrivateDir

From help:
Use PrivateDir to set the directory in which to store temporary table processing files
for all database connections, such as those generated by the BDE
to handle local SQL statements.
Ordinarily this value is only set at runtime,
so that a user’s local hard disk is used to store temporary files.
Local storage of these files improves performance.
If no value is specified for PrivateDir, the BDE automatically stores
temporary files in the directory current at the time the BDE was initialized.


0
 
MatveyCommented:
Should be the same: look at DbiSetPrivateDir function in the BDE API help.

If you want to set the temporary directrory for 'C:\Temp', for example, you make a call like this:

Dir := 'C:\Temp';
Check(DbiSetPrivateDir(PChar(Dir)));

Good luck, bosism@netvision.net.il
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now