freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: M A <manwar1tech AT yahoo.com>
To: freetds <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Error when using nocount, insert and print statements together.
Date: Wed, 26 Oct 2005 11:53:15 -0700 (PDT)

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
--ma

__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

[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