Solved

SQL temp tables

Posted on 1998-07-09
3
371 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 ???
0
Comment
Question by:dotan
  • 2
3 Comments
 
LVL 3

Accepted Solution

by:
vladika earned 50 total points
ID: 1357433
Try to use
TSession.PrivateDir

0
 
LVL 3

Expert Comment

by:vladika
ID: 1357434
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
 
LVL 3

Expert Comment

by:Matvey
ID: 1357435
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question