Mega Search
23.2 Million


Sign Up

Make a donation  
Multi variable results from Stored procedure [Edit]  
News Group: embarcadero.public.delphi.database.firedac

How to obtain multi results from Stored procedure (MSSQL Database) using FireDac components.
Procedure returns one variable contains 4 and I don't know how to obtain it my code: 

{code}

Baza.Dane.Haslo.Prepare;

  baza.dane.haslo.params[0].Value:=153;
  baza.Dane.Haslo.Params[1].Value:='UFD';

 baza.Dane.Haslo.ExecProc;

 wy:= baza.dane.haslo.params[0].asinteger;                            // Here I get one strange results
glowny.IdLogowania:=baza.dane.haslo.params[1].asinteger;     // There's nothing

{code}

Edited by: Sebastian Kumor on Jan 9, 2015 2:26 AM

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 9-Jan-2015, at 2:26 AM EST
From: Sebastian Kumor
 
Re: Multi variable results from Stored procedure  
News Group: embarcadero.public.delphi.database.firedac
> {quote:title=Dmitry Arefiev wrote:}{quote}
> http://docwiki.embarcadero.com/RADStudio/XE7/en/Command_Batches_(FireDAC)
> 
> -- 
> With best regards,
> Dmitry Arefiev / FireDAC Architect

Thank You Dmitry,
It helped me a lot

Could You please look also at https://forums.embarcadero.com/message.jspa?messageID=684217#684217

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 9-Jan-2015, at 5:55 AM EST
From: Sebastian Kumor
 
Re: Multi variable results from Stored procedure  
News Group: embarcadero.public.delphi.database.firedac
http://docwiki.embarcadero.com/RADStudio/XE7/en/Command_Batches_(FireDAC)

-- 
With best regards,
Dmitry Arefiev / FireDAC Architect

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 9-Jan-2015, at 3:39 AM EST
From: Dmitry Arefiev