[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