freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

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

[freetds] Error when using nocount, insert and print statements together., M A, 10/21/2005
- <Possible follow-up(s)>
- Re: [freetds] Error when using nocount, insert and print statements together., Lowden, James K, 10/24/2005
- Re: [freetds] Error when using nocount, insert and print statements together., ZIGLIO, Frediano, VF-IT, 10/25/2005
- Re: [freetds] Error when using nocount, insert and print statements together., Lowden, James K, 10/25/2005
- Re: [freetds] Error when using nocount, insert and print statements together., M A, 10/26/2005
  - Re: [freetds] Error when using nocount, insert and print statements together., Frediano Ziglio, 10/27/2005