Article View: borland.public.vdbase.data.sql
Article #273Re: sql table name
From: Greg Hill
Date: Mon, 21 Dec 1998 00:00
Date: Mon, 21 Dec 1998 00:00
32 lines
1479 bytes
1479 bytes
>doesn't a query on-fly create a table when u activate it ? >i think so, some like "_qsql123.dbf" ! >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 ? >thanks >Blup (it is not my real name) >Frank (Italy) You could modify the Query and insert the ALIAS parameter. This might lead to problems if your going to be running the query more the once. The following example should help you: Select * from MyTable ALIAS MyName Another challenge is to figure out how this fits in to the OODML with VDB7.x, I'm not versed in that language yet. The other option is at the proper place in your code you could use the following to obtain the name: cAlias = ALIAS() && still might be more to it in VDB7.x Now you can select the table by doing the following: Select &cAlias Greg Hill
Technical Details
Message-ID:
<75k89f$6f815@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<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: "Greg Hill" <ghill@n2.net> Subject: Re: sql table name Date: 1998/12/21 Message-ID: <75k89f$6f815@forums.borland.com> X-Deja-AN: 424355284 References: <75injb$5g71@forums.borland.com> <367d3d45.2941429@forums.borland.com> <75jorh$6f72@forums.borland.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql