Skip to Content.
Sympa Menu

freetds - Re: [freetds] Error when using nocount, insert and print statements together.

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Error when using nocount, insert and print statements together.
  • Date: Thu, 27 Oct 2005 23:14:31 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page