[freetds] Error when using nocount, insert and print statements together.
M A
manwar1tech at yahoo.com
Wed Oct 26 14:53:15 EDT 2005
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
More information about the FreeTDS
mailing list