how to get permanent sql-answer-table instead of a temporary one?

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

Article #20

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

#20

From: tt
Date: Mon, 08 Feb 1999 00:00

19 lines
1157 bytes

how to get permanent sql-result-table instead of a temporary one?

hello everybody!

what can i do to get a permanent table out of my sql-query instead of a
temporary one that is deleted after closing the session (vdb 7)?

the only solution that i can think of is creating the table and then
filling it up with the query. but this is a lot of work. is there an
easier way?

(queries in paradox automatically create a table called "answer" which
can be renamed for later use. pdx 4.5 does this for sure, newer versions
probably too. something like this would be great.)

any help is welcome.

thanks in advance,
thomas trautwein

Technical Details

Message-ID: <36BE29CB.DF161861@trautwein.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,10948d881a86ab50
X-Google-Attributes: gidff5a1,public
From: tt <thomas@trautwein.com>
Subject: how to get permanent sql-answer-table instead of a temporary one?
Date: 1999/02/08
Message-ID: <36BE29CB.DF161861@trautwein.com>
X-Deja-AN: 441825885
Content-Transfer-Encoding: 7bit
Organization: Another Netscape Collabra Server User
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql