FreeTDS Development Group

["Polyanovskyi, Sasha" <sasha.polyanovskyi AT oa.com.au>]

Sorry, another question :-)

For some reason the following two procedures work differently... The first
one needs TWO calls to dbresults() to process columns, return values, and
return status, whilst the second one -- needs THREE calls to dbresults(). 

The first case works as expected... In the second case I need to do TWO
calls to dbresults() at the beginning (instead of the expected ONE call),
then process columns, then do another call to dbresults(), then process
return values...

The difference between the procedures is the order of the first two
statements in the procedure body

_________________________________________

CREATE PROCEDURE myProc
(
      @total int OUTPUT
)
AS
BEGIN
     select * from indial

     SELECT @total = COUNT(*) from service

     declare @sum int
     set @sum = @total + 5
     return @sum
END

_________________________________________


CREATE PROCEDURE myProc
(
      @total int OUTPUT
)
AS
BEGIN
     SELECT @total = COUNT(*) from service

     select * from indial

     declare @sum int
     set @sum = @total + 5
     return @sum
END