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




Archive powered by MHonArc 2.6.24.

Top of Page