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
To: IBObjects@yahoogroups.com
Subject: [IBO] FieldName not found on SP


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

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.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/