Subject | Re: [IBO] Get WHERE clause |
---|---|
Author | Martin D. Berezaga |
Post date | 2003-01-04T18:53:53Z |
> >My problem is that I'm intending to do a DML with an IB_DSQL, like:Thanks, but I want to use the WHERE clause in an UPDATE.
> >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.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------