🚀 go-pugleaf

charles richards wrote:
> I was frustrated that an SQL result set from the VISUAL tools was not
> available to the Command Window. 

Yes, I was too.  Access will let you export the data once you have a
result set, so far VDB won't.  What I've done, once I know the query is
working, is to take the SQL query and generated a .DBF file with it...
usually that's what I need anyway.  I use the following code snippet
which came out of the help file:

d = new Database()

d.databaseName = "CONTACTSODBC"  // or whatever your database is named
d.active = true
q = new Query()
q.database = d
q.sql = "@c:\contacts\OrgCont.sql"  // the SQL file generated by the SQL
designer
q.unidirectional=TRUE  //  These two lines aren't in the help file, but
I get the
q.RequestLive=FALSE    //  error that the table is Read Only otherwise.
q.active = true

u = new UpdateSet()

u.source = q.rowset
u.destination = "C:\CONTACTS\ORGCONT.DBF"  // the destination DBF
u.copy()

This copies all of the rows from the SQL query into the DBF.  Good luck!

Phil Frank