How can I generate SQL statements with Parameters which will solve the following :

Select * From ITMS Where (FTHR=0) Order by ITEM_NM
Select * From ITMS Where (FTHR<>0) Order by ITEM_NM


This only solve the first one :
Select * From ITMS Where (FTHR=:M1) Order by ITEM_NM
// M1 =0


Thanks

Hi,

Either you'll use two different query components, with their specific clauses and the same parameter or you'll build the string for the TADOQuery.SQL property dynamically with the parameter value hardcoded in the clause.

Regards