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

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

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by tt Mon, 08 Feb 1999 00:00

#19

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

17 lines
1094 bytes

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

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

#21

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

1 lines
653 bytes

thanks geoff, that SAVE TO was exactly what i was looking for.

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

#22

Author: Geoff S. Wass
Date: Mon, 08 Feb 1999 00:00

14 lines
949 bytes

Thomas,

There is more than one way. SQL has a clause "SAVE TO" which allows you
to keep the output:  SELECT * FROM yourTable SAVE TO myTable

You can also use the updateSet.copy( ) property to ask dBASE to copy the
result set (rowset) for you.

--
Geoff Wass
Kuala Lumpur, Malaysia


=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=

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

#23

Author: Geoff S. Wass
Date: Tue, 09 Feb 1999 00:00

10 lines
807 bytes

Thomas,

You're welcome, glad it worked! :-)

--
Geoff Wass
Kuala Lumpur, Malaysia


=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads