Subject Re: [IBO] Get WHERE clause
Author Martin D. Berezaga
> >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
---------------------------