| View previous topic :: View next topic |
| Author |
Message |
Lou Feliz
Guest
|
 Posted: Tue Dec 23, 2003 7:25 am Post subject: Stored Prod Param Help |
 |
|
I am using ADO with SQL 7 and want to pass a parameter to a SP that will
return a string. My SP has one input param and one output parm. The
input parm is @Name and the output parm is VALUE
The parameters are set to the correct type. I try and set parameter by
calling TSTProc.Parameters[1].Value := 'INPUTVAL'. At runtime I get an
OleException - Parameter Object is improperly defined or inconsistent info
provided.
I will revert o using a simple query to pull the values. Although, a SP is
what my DBA wants me to use.
Any help greatly appreciated.
- Lou
|
|
| Back to top |
|
 |
Tony J Hopkinson
Guest
|
| Posted: Wed Dec 24, 2003 11:16 pm Post subject: Re: Stored Prod Param Help |
|
|
The only reason to use a TStoredProc component apart from 'neatness'
is if you want a return value.
a TQuery witrh an exec statement will do just as well the DBMS won't
care at all.
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
