🚀 go-pugleaf

On 16 Apr 1998 16:18:08 GMT, "Tom Gleaton" <tgleaton@linkline.com>
wrote:

>Vdb 7.01
>
>sql = "select * from customer where custno = :form.custno SAVE TO temp"
>
>How do I create a new database from the results of a select?
>I don't see anything in OLH but recall someone here saying it is supported?
>Is it SAVE TO or COPY TO ? What is syntax?

Tom,

I think one way to do it is to use the copyTable() command for the
parent table and then you might be able to:

  insert into <new table> select * from...

Or you could use DML before you establish the query to do a copy
structure with production to <new table>. This way the table is ready
for the insert command. There are limitations to the insert command,
but I've had it work fine for many situations.

Ned