Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- From: Marc Scheuner <no.spam@xxxxxx>
- Date: Wed, 27 Apr 2005 08:59:44 +0200
> adosp.Parameters.CreateParameter('RESULT_VALUE',ftCurrency,
>pdReturnValue, 10, 0);
> ADOSP.Parameters.CreateParameter('guestID',ftString, pdInput, 10,
>trim(adodsGuests.FieldValues['guestid']));
> ADOSP.Parameters.CreateParameter('meetingCode',ftString, pdInput, 6,
>trim(adodsGuests.FieldValues['meetingCode']));
> ADOSP.prepared := true;
> ADOSP.Open;
Everything okay, but since the stored proc does not return a result
set, you should not call .Open on it - use .ExecProc instead. After
that, you should be able to access your "RESULT_VALUE".
Marc
.
- References:
- Prev by Date: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Next by Date: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Previous by thread: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Next by thread: Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
- Index(es):