Subject | parms in sql statements, NOT stored procedures |
---|---|
Author | Lee Catlett |
Post date | 2001-03-07T15:02:58Z |
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
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