Improve company productivity with a Business Account.Sign Up

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

_QBSQL000.DBF Files??

Hi there,
         I have a question regarding the temporary files types created when running a Delphi 3 App that incorporates
Datamodules. Why are these files created (sometimes on the desktop) and how can I prevent them from being created in the programs directory. Any ideas would be appreciated.

Regards WESTY :)

0
westy100697
Asked:
westy100697
  • 3
  • 2
  • 2
1 Solution
 
Ronald BusterOwnerCommented:
These are temporary files. I guess to you make a query with a TQuery component therefore, the bde makes a temporary database in the current directory. You cannot
prevent this the only way to prevent this is : do not use a TQuery component use TTable components and link them (if you have a query with more than one database) with keyfields.

If you need further help with this please feel free to ask me okay.

regards,

cono
0
 
westy100697Author Commented:
cono,
        Alas I guessed they were derived from a TQuery already since (_QSQL) but I may be guessing here I have Dll's in this project as well and to use them I have to create them in the Dll source. Is this the source of the _QSQL files ie on the creation of the Datamodule object. I ask this as this is the source of all my queries and tables. Also in the forms I have been accessing there are only links to TTable components and no links to TQuery. This is why I have found it so bizarre. I give you an example. I have checked before executing the program for any _QSQL files and there are none. I can then run the program and without actually accessing a Query component these temporary files are created. The difference has been that I am unable to delete these at the runtime of the program. As soon as I exit the program they disappear. It is very strange as when I actually use a Query component a permanent file is recorded in the program directory and I then must manually delete. Very very strange I reckon.
0
 
Oli2Commented:
Try TSession.PrivateDir.
See Delphi Help on this !

Greetings, Oli
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

 
westy100697Author Commented:
Cono,
         I am going to reject your answer as I tried what Oli2 said and he eas spot on. Works like a charm Oli2 so if you want the points lock the question and thanks for your help.

Regards WESTY :)
0
 
Ronald BusterOwnerCommented:
Ok the TSession.PrivateDir is a solution but the temporary files still remain. This is not really solving your problem or not ?

greets

Cono

0
 
Oli2Commented:
Thanx, Westy !
The answer was: TSession.PrivateDir

Greetings, Oli
0
 
westy100697Author Commented:
Oli2,
       Thanks for the answer works well. Cono this sis solve the problem as the files were preventing dbf's from being backed up. So by pointing the TSession.Privatedir I was able to eliminate the problem. Hope this clears it up. Thanks for your help too though.

WESTY :)
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.

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