Subject | query parms? NOT stored procedures |
---|---|
Author | Lee Catlett |
Post date | 2001-03-07T15:40:23Z |
Can someone enlighten this new unenlightened IB person on how to do the
following.
I have several tables defines like:
table
firstid char(30)
secondid char(30)
etc...
where firstid is a key and the next is not
When I try and do a
(select * from table where firstid =: firstid and secondid =: secondid
I get an error about secondid being invalid.
How do you work with parms in ib if this is not valid?
Thanks to all or anyone.
lee
following.
I have several tables defines like:
table
firstid char(30)
secondid char(30)
etc...
where firstid is a key and the next is not
When I try and do a
(select * from table where firstid =: firstid and secondid =: secondid
I get an error about secondid being invalid.
How do you work with parms in ib if this is not valid?
Thanks to all or anyone.
lee