Stored procedure is recordsource for form and should return a parameter. How?

  • Thread starter Thread starter furkat
  • Start date Start date
F

furkat

Hi All

one of my forms is based on the results of stored procedure (that is
Form.RecordSource="exec MySP")
MySP has an output parameter as well. How can I get this parameter from this
stored procedure? I can't call it twice as output parameter can change...

Thanks

Furkat
 
Re-write the stored procedure's output parameter value as an
additional column in the SELECT statement. You['ll get the value in
every row in the result set, but you don't need to display it in a
control on the form. Access forms aren't designed to handle output
parameter values.

--Mary
 
Thanks,
it works...
Furkat

Mary Chipman said:
Re-write the stored procedure's output parameter value as an
additional column in the SELECT statement. You['ll get the value in
every row in the result set, but you don't need to display it in a
control on the form. Access forms aren't designed to handle output
parameter values.

--Mary

Hi All

one of my forms is based on the results of stored procedure (that is
Form.RecordSource="exec MySP")
MySP has an output parameter as well. How can I get this parameter from this
stored procedure? I can't call it twice as output parameter can change...

Thanks

Furkat
 
Back
Top