Try doing a MyQuery.SQL.Assign( AnotherQuery.SQL )

Another way for a little different result is to use the
MyQuery.AssignSQLWithSearch( AnotherQuery ) method.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "stanw1950" <stanw@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, May 01, 2002 2:42 PM
Subject: [IBO] Copy sql from one tib_query to another


> What's the best way to assign all the sql (the select, from, where,
> and ordering) from one tib_query to another tib_query? Thanks in
> advance.
>
> Stan Walker
>