[Info-ingres] OpenAPI Parameter Place Holders -
09-30-2005
, 07:59 AM
Hi Grant et al,
If you have a spare second or two....
Is there any difference between using the '?' place holder for an SQL
statement and using a '~V'?
eg insert into fred values(?,?,?,?) works.
But if we change the '?' to space tilda V space. The query fails with
either:
Illegal binarty value in query text
or
OpenAPI function cannot be called in current state.
We get the first if we set queryParm.qy_parameters=FALSE or TRUE
respectively.
The manual suggests these are equivalenet and hints that ~V is
preferred - although we may be reading too much into that...
Martin Bowes
--
Random Duckman Quote #89:
Cornfed: I'm sorry I slapped you Duckman, but I was trying to calm you
down.
Duckman: And I guess just saying "calm down" would be considered
hopelessly
simplistic! |