Subject parms in sql statements, NOT stored procedures
Author Lee Catlett
Can someone enlighten this unenlightened rather new person to IB query
constructs. I'm trying to migrate an app fro SQL to IB and have dozens
of queries of the following nature:

select *
from atable
where firstID =: firstID
and secondID =: secondID

from a table like:

firstID char(30)
secondID char(30)
etc.....

with firstID being the only key. The error returned states that it
doesn't know what secondID is. Since they are both used as parms and
their values set in code, how do you do this in the IB world, if you can
at all. Thanks
Lee