We help IT Professionals succeed at work.

SQL temp tables

dotan
dotan asked
on
394 Views
Last Modified: 2013-11-23
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 ???
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Commented:
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.


Commented:
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
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.