Have a look at the ServerSQL property if you want what exactly was sent to
the server.

Also, AssignSQLWithSearch is necessary to pick up the search criteria's
impact on the WHERE clause.

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

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Martin D. Berezaga" <mdberezaga@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, January 04, 2003 11:53 AM
Subject: Re: [IBO] Get WHERE clause


>
> > >My problem is that I'm intending to do a DML with an IB_DSQL, like:
> > >UPDATE TABLE
> > >SET FIELD = VALUE
> > >But I want to do the UPDATE in the same rows affected by the IB_Query.
> > >
> > >I'm trying use the IB_Query.SQLWhere property, but it seems not to
include
> > >the search criteria used by the query.
> > >
> > >How can I get the complete WHERE clause sended to the server by the
> > IB_Query?
> > >
> > >Thanks in advance.
> > >
> > >
> > >
> >I do not know about the IB_DSQL component but with an IB_Query you can
> >use the AssignSQLWhere method. I use this to get updated summary totals
> >for the users.
>
> Thanks, but I want to use the WHERE clause in an UPDATE.
>
>
> ---------------------------
> Martin D. Berezaga
> mdberezaga@...
> ICQ : 18537142
> Porto Alegre - RS - Brasil
> ---------------------------