Subject Re: [IBO] Get WHERE clause
Author Andrew
Martin D. Berezaga wrote:

>My problem is that I'm intending to do a DML with an IB_DSQL, like:
>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]