Subject | using IB_query.invalidatesql, IB_query.refresh on IB_query.onpapared with IB_que |
---|---|
Author | james_027 |
Post date | 2003-07-01T03:55:09Z |
Before when Iam writing a Program and when the user wants to perform
a search what I do is get the value from the edit.text then closes
the query and edit the query.sql then re open it again. Something
like this
query.close;
query.sql[1]:='where name start with '''+edit.text+'''';
query.open;
Now when Iam using the IBO what I did is edit the
IB_query.sqlwhereitems on IB_query.onprepare event when the
IB_query.invalidatesql and IB_query.refresh is call
Am I doing the right and the best practice?
a search what I do is get the value from the edit.text then closes
the query and edit the query.sql then re open it again. Something
like this
query.close;
query.sql[1]:='where name start with '''+edit.text+'''';
query.open;
Now when Iam using the IBO what I did is edit the
IB_query.sqlwhereitems on IB_query.onprepare event when the
IB_query.invalidatesql and IB_query.refresh is call
Am I doing the right and the best practice?