Re: Bunch of SQL open

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

Article #293

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

#293

From: David M. O'Neil
Date: Sat, 26 Dec 1998 00:00

25 lines
1261 bytes

Here is the line that figure the total:

select sum((rate* N_of_pages)+ price) tot_inv, sum(Etax) t_Etax from bill
where bill_n= :t_recno

When this line is run a couple of times I end up with two new dbf files.
Like "_qsql123.dbf" and "_qsql144.dbf" After awhile you get the error,
"Two many files open." So I would like to close these dbf files after I
obtain the results.

Thanks in advance,

David

Bowen Moursund (TeamB) wrote:

> >I have some code...
>
> If you post the relevant bits, perhaps someone can offer a suggestion.
> ____
> Bowen Moursund (TeamB)
> bowen at nerds dot com
> http://lonestar.texas.net/~moursund/
> Try this help resource:
>  http://www.dejanews.com/home_ps.shtml

Technical Details

Message-ID: <36850D4F.AACE8665@ONeilComputing.com>

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

References: <36819874.659232AA@ONeilComputing.com> <75u0jt$fdm3@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,b11ae58a0bc6f72d
X-Google-Attributes: gidff5a1,public
From: "David M. O'Neil" <David@ONeilComputing.com>
Subject: Re: Bunch of SQL open
Date: 1998/12/26
Message-ID: <36850D4F.AACE8665@ONeilComputing.com>
X-Deja-AN: 425941235
Content-Transfer-Encoding: 7bit
References: <36819874.659232AA@ONeilComputing.com> <75u0jt$fdm3@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: OCC
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message