Re: Bunch of SQL open

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

Article #294

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

#294

From: Bowen Moursund (TeamB)
Date: Sat, 26 Dec 1998 00:00

16 lines
1254 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

You can use the SAVE TO option of SELECT to specify an actual on-disk table
name, or use the ALIAS option to specify the alias of the open result set.
Either way, just ensure that you close the result with the USE command when
you're finished with it. That should also close any temporary tables as
well.
____
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: <7634mg$iu24@forums.borland.com>

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

References: <36819874.659232AA@ONeilComputing.com> <75u0jt$fdm3@forums.borland.com> <36850D4F.AACE8665@ONeilComputing.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: "Bowen Moursund (TeamB)" <teamb@opto-pps.com>
Subject: Re: Bunch of SQL open
Date: 1998/12/26
Message-ID: <7634mg$iu24@forums.borland.com>
X-Deja-AN: 425951087
Content-Transfer-Encoding: 7bit
References: <36819874.659232AA@ONeilComputing.com> <75u0jt$fdm3@forums.borland.com> <36850D4F.AACE8665@ONeilComputing.com>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message