[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