🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: sql table name

#275
From: Ken Mayer [TeamB]
Date: Mon, 21 Dec 1998 00:00
25 lines
1428 bytes
"Blup" <fpagliaro@cys.it> wrote:

>doesn't a query on-fly create a table when u activate it ?
>i think so, some like "_qsql123.dbf" !

That's a temporary file that gets deleted when done. (Unless you crash
the software, or something like that ...)

>i need to append the created rowset to an existing table!
>actually i have to <ref>.copy() to a temptable and then append it to the old
>one.
>how can i skip the temptable pass ?

There are a lot of ways. If you are using VdBASE 7, check out the
UPDATESET class. There are details on its use at my website in the
MISCCODE.ZIP howto document.

Ken
---
Ken Mayer [TeamB]
Golden Stag Productions
http://www.mindspring.com/~hirschv/homepage.htm
http://www.mindspring.com/~hirschv/dbase/dbase.htm
Visual dBASE and InterBase WebRing - http://www.fghoche.com/dbasering.htm
TeamB: http://www.inprise.com/newsgroups/teamb/whatisteamb.html
Technical Details
Message-ID: <367dc5b6.23282718@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <75injb$5g71@forums.borland.com> <367d3d45.2941429@forums.borland.com> <75jorh$6f72@forums.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,f163b3e933edb80d
X-Google-Attributes: gidff5a1,public
From: supportInfo@borland.com (Ken Mayer [TeamB])
Subject: Re: sql table name
Date: 1998/12/21
Message-ID: <367dc5b6.23282718@forums.borland.com>
X-Deja-AN: 424384384
References: <75injb$5g71@forums.borland.com> <367d3d45.2941429@forums.borland.com> <75jorh$6f72@forums.borland.com>
Organization: Golden Stag Productions
Reply-To: teamb@opto-pps.com
Newsgroups: borland.public.vdbase.data.sql