Subject | AssignSQLWithSearch don't accept parameters |
---|---|
Author | Arn |
Post date | 2010-01-21T08:00:11Z |
Hi All.
I must pass the SQL of a TIB_Query to a TIBOQuery.
AssignSQLWithSearch works only scanning the entire table: e.g.
1) "SELECT * FROM TABLE1". Works.
2) "SELECT * FROM TABLE1 WHERE ( FIELD1 = ?P1 )". ----> DON'T Works.
the second case returns an empty query.
This command seems to be useless, so I think there is a problem.
How to pass the snapshot?
Comments?
Thanks
Arn
I must pass the SQL of a TIB_Query to a TIBOQuery.
AssignSQLWithSearch works only scanning the entire table: e.g.
1) "SELECT * FROM TABLE1". Works.
2) "SELECT * FROM TABLE1 WHERE ( FIELD1 = ?P1 )". ----> DON'T Works.
the second case returns an empty query.
This command seems to be useless, so I think there is a problem.
How to pass the snapshot?
Comments?
Thanks
Arn