Skip to Content.
Sympa Menu

freetds - [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: [freetds] Error when using nocount, insert and print statements together.
  • Date: Fri, 21 Oct 2005 11:40:20 -0700 (PDT)

Hi,
This might be related to the previous post for the same error, but this will
show up every time.

The following error is reported when a certain executing a certain set of
commands in a stored procedure. On the previous version it would not execute
all the statements but on version 0.63 it reports the following error.

Attempt to initiate a new SQL Server operation with results pending.

This is using the stable releaese of freetds: version 0.63


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

Now call the testProc from freetds using
dbcmd("exec testProc")


and the error will show up.
however the following set of commands work..
It seems like set nocount on followed by an insert statement followed by a
print statement will fail.

Here are examples of passing queries :
Call "alter proc testProc" and remove the appropriate line.

Example 1: no print after insert

set nocount on
insert into test_api values(getDate(), 1)
insert into test_api values(getDate(), 2)
select updated_date,id from test_api
print 'Did the select'


Example 2: no insert statement
set nocount on
print 'About to call select'
select updated_date,id from test_api
print 'Did the select'

Example 3: no "set nocount on" statement
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'




---------------------------------
Yahoo! FareChase - Search multiple travel sites in one click.




Archive powered by MHonArc 2.6.24.

Top of Page