Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

SQL temp tables

Posted on 1998-07-09
3
370 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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
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…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

861 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