🚀 go-pugleaf

In article <01bd6955$04033e60$4a4c96d1@dict2>, tgleaton@linkline.com 
says...
> 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?
> 
> -- 
> Thanks,
> Tom Gleaton
> County of Riverside,  Riverside California
> 

How about just saving it to the rowset and using CLASS updateset


function load_my_query_into_a_new_databasefile
private m
m=form.custno
m='"'+m+'"'
oFoo=new Query()
oFoo.sql= 'select * from "customer" where custno = &m'
oFoo.active=true
u=new updateset()
u.source=oFoo.rowset
u.destination=temp.dbf
u.copy()


It's blinding fast!!
 
-- 
Gerald Fay
gjfay@msn.com