Is this a bug or ..?
Posted: Wed 09 Aug 2017 11:55
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):
However, your UniStoredProc1 is only returning the first select count statement (SKUPAJ_NAVADNA). Other 2 are ignored.
Why ?
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';
ENDWhy ?