Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!

> adosp.Parameters.CreateParameter('RESULT_VALUE',ftCurrency,
>pdReturnValue, 10, 0);
> ADOSP.Parameters.CreateParameter('guestID',ftString, pdInput, 10,
>trim(adodsGuests.FieldValues['guestid']));

Your parameter name is incorrect - the parameter in the MS-SQL stored
proc is "@guestID", so you need to create a parameter with that name,
too - don't drop the @ from the parameter name !

Also, since MS-SQL stored proc parameters always have to have a @ as
their first character, try the same for your return value:

adosp.Parameters.CreateParameter('@RESULT_VALUE', ftCurrency,
pdReturnValue, 10, 0);

Marc

.

Relevant Pages

  • Najdrozsi poslowie traca
    ... proc. ... znalazlaby sie poza Sejmem. ... Prev by Date: ...
    (soc.culture.polish)
  • Re: Where is the history stored (bash)?
    ... >>> where in proc? ... If you're going to use google groups to post, ... #bofh excuse 22: monitor resolution too high ... Prev by Date: ...
    (comp.unix.shell)
  • Mathmatical operators in VBA code
    ... I copied the following formula from a proc I had that checked for positive ... For Each mvt In RangeIf mvt.Value = 101 Then ... If rangeToSelect Is Nothing Then ... Prev by Date: ...
    (microsoft.public.access.devtoolkits)
  • Mathmatical operators in VBA code
    ... I copied the following formula from a proc I had that checked for positive ... For Each mvt In RangeIf mvt.Value = 101 Then ... If rangeToSelect Is Nothing Then ... Prev by Date: ...
    (microsoft.public.access.devtoolkits)
  • Re: stored proc RETURN_VALUE.... there it is, I want to use it !!!
    ... I can't seem to get a result out of this stored proc... ... I've done this loads of times... ... ADOSP.Parameters.CreateParameter('meetingCode',ftString, pdInput, 6, ... >> sql help that it states that stored procedures don't return values??? ...
    (borland.public.delphi.database.ado)