[freetds] Error when using nocount, insert and print statements together.
Frediano Ziglio
freddyz77 at tin.it
Thu Oct 27 17:14:31 EDT 2005
Il giorno mer, 26/10/2005 alle 11.53 -0700, M A ha scritto:
> From: ZIGLIO, Frediano, VF-IT
> > Sent: Tuesday, October 25, 2005 5:38 AM
> >>> From: M A
> >>> Sent: Friday, October 21, 2005 2:40 PM
> >>> ...
> >>> To reproduce the error create the table and stored
> procedure on
> >>> SQL server using the following code:
> >>>
> >>> create table test_api([updated_date] datetime,
> [id] int)
> >>>
> >>> create proc testProc
> >>> AS
> >>> BEGIN
> >>> set nocount on
> >>> insert into test_api values(getDate(), 1)
> >>> insert into test_api values(getDate(), 2)
> >>> print 'About to call select'
> >>> select updated_date,id from test_api
> >>> print 'Did the select'
> >>> END
> >
> > Try with this patch (works for me)
> > [excellent patch snipped]
>
> >Looks good! Committed:
>
> Tested out with 0.63 works fine
> Thanks for the fix
?? how this is possible ?? patch I proposed do not works for 0.63 ... a
more complicated back porting is needed.
freddy77
More information about the FreeTDS
mailing list