Subject | Get WHERE clause |
---|---|
Author | Martin D. Berezaga |
Post date | 2003-01-02T21:46:23Z |
I have an IB_Query, which SQL doesn't include a WHERE clause, just like:
SELECT * FROM TABLE
I use an IB_SearchBar, so it's possible to change the rows affected by the
SELECT.
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.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------
SELECT * FROM TABLE
I use an IB_SearchBar, so it's possible to change the rows affected by the
SELECT.
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.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------