Subject RE: [IBO] FieldName not found on SP
Author Don Schoeman
Preparing the query first helps the stored proc refresh it's parameter list,
but why do I have to perform an implicit prepare for the stored proc where
everywhere else I do not have to? The Prepared property is set to True.

-----Original Message-----
From: Don Schoeman [mailto:don@...]
Sent: 06 December 2001 15:00
Subject: [IBO] FieldName not found on SP

I get the following error when trying the set a parameter value for a stored

FieldName: P_UNIT_TYPE_ID not found

I know for a fact that the P_UNIT_TYPE_ID parameter does exist and it is
listed in the ParamNames and Params properties.

I set the parameter value like this:
spCreateUnitCodes.Params.ParamByName('P_UNIT_TYPE_ID').AsInteger := xxx;

I've been doing this all over the place and everywhere else it does work.
Any ideas?

Best Regards,
Don Schoeman

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to