Hi,  I have a problem with the result of an SQL statement and I'm not sure
why.  When trying to run an SQL, an SQL Script Error occur with the message
"Insufficient disk space"  (BDE Error 9475).

Is it a disk space? I got enough space...  Is it a RAM space?  Virtual
memory space?  Does the tables involve in the SQL have too many record for
being join together?

Thanks,

Michel
(mgau...@oaot.com)

: Hi,  I have a problem with the result of an SQL statement and I'm not sure
: why.  When trying to run an SQL, an SQL Script Error occur with the message
: "Insufficient disk space"  (BDE Error 9475).

: Is it a disk space? I got enough space...  Is it a RAM space?  Virtual
: memory space?  Does the tables involve in the SQL have too many record for
: being join together?

The BDE will create temporary tables, some of which can be quite
large, in the designated temporary directory for the session.  In
Delphi, by default the temporary directory is the directory of the
executable.  My suspicion is that the drive you're running the EXE
from does not have the space.  Designate a different path by setting
a value (the path as string) for Session.PrivateDir.  Each simultaneous
user of your application, and each BDE application being run on the
same computer, must have a unique private directory, so a directory
off the local
hard drive is what's normally used.
--
Rick Carter
carte...@email.uc.edu