(just guessing)...

I don't think TIBOQuery has a ParamChar property and you seem to use '?' rather than the standard ':' as your ParamChar. Does it work if you change TIB_Query.ParamChar to ':' (and modify your query accordingly)? I would be surprised if AssignSQLWithSearch generally didn't work with parameters (I think quite a few persons use it), but it might not be equally common to change the ParamChar.

Set

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf Of Arn
Sent: 21. januar 2010 09:00
To: IBObjects@yahoogroups.com
Subject: [IBO] AssignSQLWithSearch don't accept parameters

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