 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Bartek
Guest
|
 Posted: Wed Jan 05, 2005 12:42 pm Post subject: TQuery, insuficient memory, too many tables open |
 |
|
Hi,
I use: TQuery component for retrieving some information and DBASE and
Paradox databases, Delphi 4 Prof., BDE which was delivered with Delphi 4.
The problem is:
The amount of memory that my program is using is growing each time I
retrieve some information using TQuery component.
And after couple operations I got an error:
Insuficient memory for this operation
sometimes I also get error like this:
Too many tables open.
I work with dBase tables or Paradox, there are about 7 tables opened and one
query (for getting some information).
I tried to change:
SharedMemSize to 4096, 8192 etc. but then I got an error BDE $251E (too
many session open) ? I have just one alias connected with the session.
Any ideas what should I do?
Maybe there is some function that tell to free all memory that TQuery is
using each time I wanna use it again or something like this ? Correct me if
I think wrong
thanks in advance
Bartek
|
|
| Back to top |
|
 |
Bill Todd
Guest
|
| Posted: Wed Jan 05, 2005 1:08 pm Post subject: Re: TQuery, insuficient memory, too many tables open |
|
|
Try closing and opening the session.
Session.Close;
Session.Open;
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
|
|
| Back to top |
|
|
Bartek
Guest
|
| Posted: Wed Jan 05, 2005 1:45 pm Post subject: Re: TQuery, insuficient memory, too many tables open |
|
|
It works, thx Bill,
Btw I wonder if there is any free alternative for BDE to deal with DBASE and
PARADOX tables?
Bartek
|
|
| Back to top |
|
|
Rick Carter
Guest
|
| Posted: Wed Jan 05, 2005 3:55 pm Post subject: Re: TQuery, insuficient memory, too many tables open |
|
|
| Quote: | It works, thx Bill,
Btw I wonder if there is any free alternative for BDE to deal with DBASE
and
PARADOX tables?
|
If you're keeping the Paradox table format, you'll need to keep the BDE.
There are other alternatives, like Advantage Database Server (the local
server is free), that make the transition simpler and may not require
that much code to be rewritten, but you would need a different file
format for the data.
There are alternatives for working with dBASE tables, icluding Advantage
Database server (supports FoxPro or Clipper style indexes and memo fields)
and tDBF.
tDBF can be found at http://sourceforge.net/projects/tdbf/
Other BDE alternatives can be found at
http://www.kylecordes.com/bag
Rick Carter
[email]carterrk (AT) despammed (DOT) com[/email]
Chair, Delphi/Paradox SIG, Cincinnati PC Users Group
--- posted by geoForum on http://delphi.newswhat.com
|
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Wed Jan 05, 2005 7:30 pm Post subject: Re: TQuery, insuficient memory, too many tables open |
|
|
If your application is single user you can use the Advantage Local Server
which is free. You can stay with dBase format if you need to for
compatibility with other applications or use their excellent convertion
utility to convert to ADT table format which offers many more features.
For multi-user apps you need to use the Advantage Database Server which is
not free. I do not know of any free dBase engines.
--
Bill Todd (TeamB)
TeamB cannot answer questions received via email
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
