Re: Interesting error message with SQL statement

Article View: borland.public.vdbase.data.sql

Article #346

Back to borland.public.vdbase.data.sql Previous Next

#346

From: Romain Strieff [TeamB]
Date: Wed, 21 Oct 1998 00:00

25 lines
1510 bytes

In article <362B3FB9.D55BF58D@notgiven.com>, mike grudgingly admits...
> I have a 150 Meg page file and the query never fails when i run the
> query from
> my local harddisk. however it will fail every time when running it from
> a network
> drive. I have supervisor access to the server so it's not a rights issue
> and I am 
> also the network administrator and have not to my knowledge set up any
> limits on 
> disk space for users. (not sure you even can, but will check into that)
> 
> I will go larger on my page file and see it that helps. (I don't think
> it will 
> but who knows).
> 
> Any other sugestions? 
> 
Are you using ORDER BY or JOIN which would create a temptable? If yes, 
just use simple SQL and do the ordering with the rowset.indexname and 
joins with the query objects methods instead of the SQL.
-- 
Romain Strieff [TeamB]
check this URL for all the copies of the
previous electronic VdB Newsletters
http://www.openenv.com/feedback/archive/VdBASE/

Technical Details

Message-ID: <MPG.1097fd72c10072b898982e@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3627A7FF.2780DE50@notgiven.com> <70fb9e$8ku14@forums.borland.com> <362B3FB9.D55BF58D@notgiven.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,99e2e557c061ca2e
X-Google-Attributes: gidff5a1,public
From: teamb@opto-pps.com (Romain Strieff [TeamB])
Subject: Re: Interesting error message with SQL statement
Date: 1998/10/21
Message-ID: <MPG.1097fd72c10072b898982e@forums.inprise.com>
X-Deja-AN: 403547590
References: <3627A7FF.2780DE50@notgiven.com> <70fb9e$8ku14@forums.borland.com> <362B3FB9.D55BF58D@notgiven.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message