It is similar but it also grabs the parameters (and their values) so I
suppose it would work, just not exactly as they wanted it to.

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

----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, April 19, 2001 6:03 PM
Subject: RE: [IBO] access to the native / executed SQL of a query


> Isn't something like AssignSQLWithSearch a method for this purpose?
>
> C.
>
> > -----Original Message-----
> > From: stahlberger@... [mailto:stahlberger@...]
> > Sent: Martes 17 de Abril de 2001 14:31
> >
> > Jason,
> > please tell me how to do this.
> > i would like to use this for copy into a IBOquery.sql on a Quickreport.
so
> > there is no need to build the statement again for printing a prior
> > selection.
> > Greetings Christian
> >
> > > > Hi,
> > > > is it possible to get the native/executed (paramvalues instead of
> > > > paramnames) sql?
> > > >
> > > > Query.SQL contains:
> > > > SELECT * FROM PUSER
> > > > WHERE PU_ID = :ID AND
> > > > PU_ACCOUNT > :ACC
> > > >
> > > > wish to get Access:
> > > > SELECT * FROM PUSER
> > > > WHERE PU_ID = 5 AND
> > > > PU_ACCOUNT > 10000
> > > >
> > > > Greetings Christian