Re: Bunch of SQL open

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

Article #302

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

#302

From: David M. O'Neil
Date: Mon, 28 Dec 1998 00:00

20 lines
1304 bytes

My code now looks like the following,

select sum((rate* N_of_pages)+ price) AS tot_inv, sum(Etax) AS t_Etax from bill
where bill_n= :t_recno save to "t_temp1.dbf"
     select tot_inv, t_Etax from temp1
  a= tot_inv
 drop temp1

Which give the following error, "Error; Table already open, temp1,"  when I try
to drop the table. How would I close this table.

David

Bowen Moursund (TeamB) wrote:

> >gives the error, "Variable undefined. TOT_INV." I didn't have this problem
> >before adding the "save to" to the statement. What's the problem?
>
> Perhaps you must USE the newly created file.
> __

Technical Details

Message-ID: <3687F21F.C2C05A74@ONeilComputing.com>

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

References:

<36819874.659232AA@ONeilComputing.com> <75u0jt$fdm3@forums.borland.com> <36850D4F.AACE8665@ONeilComputing.com> <7634mg$iu24@forums.borland.com> <3687C1C7.C5ADFCE2@ONeilComputing.com> <768n1c$noc16@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/28
Message-ID: <3687F21F.C2C05A74@ONeilComputing.com>
X-Deja-AN: 426551654
Content-Transfer-Encoding: 7bit
References: <36819874.659232AA@ONeilComputing.com> <75u0jt$fdm3@forums.borland.com> <36850D4F.AACE8665@ONeilComputing.com> <7634mg$iu24@forums.borland.com> <3687C1C7.C5ADFCE2@ONeilComputing.com> <768n1c$noc16@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