Martin D. Berezaga wrote:

>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.



[Non-text portions of this message have been removed]