Solved

SQL temp tables

Posted on 1998-07-09
3
367 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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now