Paul,
Sounds like your using NT 4.0?
I'm using a the last BETA version of 6.5++ and will test this weekend with
the latest issue of 6.5++.
I've tested this on Win95, Win98, NT4.0 Workstation and NT 4.0 Server.
It works on Win95 and Win98 just fine!
On NT 4.0 it does what you describe. I've tested it from the gateway dialog
and R> prompt same results. If I do it two times in a row it cause Rbase to
fail.
The only difference is when I select to OK button(twice from the error
message dialog box) it does work on NT, it only puts the first 10 rows in
the file.
I'll do a little more testing and report back to you and RBTI.
Sounds like a memory issue with NT and Rbase!
Best regards,
Oma
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Friday, June 22, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: Disk error using Gateway in command file.
Greetings, all.
I get this error message (TWICE, in a yes/no dialog box): "There is
insufficient disk space on either the Target Drive or the Temporary File
Drive. The operation may fail. Do you wish to continue".
when running the Gateway Export command below from the R>.
GATEWAY EXPORT QSV c:\database\catalog\bannerup\scrtxt2.qsv SELECT * +
FROM scrrare WHERE LIMIT = 10
The export does run, but the results include all 194 rows in the table.
Any rows after the LIMIT = 10 show up as all nulls.
"BIO","1114","199710",,1,"P_INCOMPL"
"BIO","1214","199920",,1,"P_INCOMPL"
"BIO","1214L","200110",,1,"P_INCOMPL"
"BIO","2102","200110",,1,"P_INCOMPL"
"BIO","2314","200020",,1,"P_INCOMPL"
"BIO","2604","200010",,1,"P_INCOMPL"
"BIO","3024","200020",,1,"P_INCOMPL"
"BIO","3104","199810",,1,"P_INCOMPL"
"BIO","3154","200020",,1,"P_INCOMPL"
"BIO","3204","200020",,1,"P_INCOMPL"
,,,,,
,,,,,
,,,,,
and so on for 194 lines, which is the number of rows I have in the table.
I have 3.7 GB plus space on the hard drive. The temporary directory is C:
\rbscrtch, it's not empty, but it doesn't have any *.$$$ files when the
command is run.
And it doesn't seem to matter what Null is (char(32), char(255), or -0-), I
always get the error dialog box TWICE before the command executes. It
also doesn't matter if I remove the LIMIT = 10 clause, I still get the
error dialog box.
Paul Patrick [EMAIL PROTECTED]
University of Central Oklahoma
Edmond, OK 73034
(405) 974-2336 fax (405) 341-4964
