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


>here's the call: (no giggling if you please! I've been slapping it around a
>bit!)
>function Tdm.GetPayments: currency;

Go back a couple of steps.
Add a TadoDataset to your datamodule.
Set the commandText to your stored procedure
make sure the parameters are created.
Set the values of the parameters to a test value.
Set the TadoDataset Active?
Do you still have a problem? If so you are probably doing something wrong in
your stored procedure.
If it works then try it in code with nothing more than setting the
TadoDataset.Active:=true;
--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: RETURN_VALUES ??? done... What have I gained?
    ... b (aka whipper-snapper) ... > similar questions via stored proc and can set up a function to do the work ... >> tAdoDataSet is really easy to use. ... >> dataset even though you are pointing to a stored procedure. ...
    (borland.public.delphi.database.ado)
  • Re: RETURN_VALUES ??? done... What have I gained?
    ... Who is Doctor Codd? ... similar questions via stored proc and can set up a function to do the work ... > tAdoDataSet is really easy to use. ... > dataset even though you are pointing to a stored procedure. ...
    (borland.public.delphi.database.ado)
  • Re: RETURN_VALUES ??? done... What have I gained?
    ... tAdoDataSet is really easy to use. ... dataset even though you are pointing to a stored procedure. ... But dont use a stored proc return code to return data ... > @total money OUTPUT AS ...
    (borland.public.delphi.database.ado)
  • Stored Procedure: CommandText does not return a result set
    ... I am trying to run the SQL Server stored procedure sp_helpindex. ... TADOStoredProc and ExecProc, ... TADODataset that runs a select against a SQL Server function and it ...
    (borland.public.delphi.database.ado)