Is this a bug or ..?

[Senad]

I use multiple select statements in a sql server stored procedure.
The sp runs ok on the server.
However when dropping your UniStoredProc1 on a form and linking it to
my sp on the server only the first field can be retrieved.
Example (this is the server sp):

Code: Select all

ALTER PROCEDURE [dbo].[sp_skupaj]
	AS
BEGIN
	  
select COUNT(dieta) as SKUPAJ_NAVADNA from STANOVALCI where NADSTROPJE in ('0 L','0 D') and dieta ='1';
select COUNT(dieta) as SKUPAJ_PASIRANA from STANOVALCI where NADSTROPJE in ('0 L','0 D') and dieta ='2';
select COUNT(dieta) as SKUPAJ_SLADKORNA from STANOVALCI where NADSTROPJE in ('0 L','0 D') and dieta ='3';

END

However, your UniStoredProc1 is only returning the first select count statement (SKUPAJ_NAVADNA). Other 2 are ignored.
Why ?

[ViktorV]

TUniStoredProc allow working with multiple results returned by a stored procedure using the OpenNext method. Call of the OpenNext method will return the following result set if only the TUniStoredProc.SpecificOptions.Values['SQL Server.DisableMultipleResults'] property is set to 'False' (by default).