G'day Paul,
What version of R:BASE?
(Versions prior to current will not recognise large drives/partitions
and will return such error messages.)
Try it on a drive/partition less than 2 gig.
At 15:18 22/06/01 -0500, you wrote:
>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
Warmest regards,
Tom Grimshaw
coy: Just For You Software
tel: 612 9552 3311
fax: 612 9566 2164
mobile: 0414 675 903
post: PO Box 470 Glebe NSW 2037 Australia
street: 3/66 Wentworth Park Rd Glebe NSW 2037
email: [EMAIL PROTECTED]
web: www.just4usoftware.com.au
This email and any files transmitted with it are confidential to the
intended recipient and may be privileged. If you have received this email
inadvertently or you are not the intended recipient, you may not
disseminate, distribute, copy or in any way rely on it. Further, you should
notify the sender immediately and delete the email from your computer.
Whilst we have taken precautions to alert us to the presence of computer
viruses, we cannot guarantee that this email and any files transmitted with
it are free from such viruses.
