FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> > 
> > Update/delete returns -1 instead of correct affected rows on Merge 
> > Publication on MSSQL 2000 SP3a.
> > 
> > Any news?
> > Thanks.
> > 
> 
> If you refer to ctlib problem with triggers nothing changed. 
> We still do
> not know if this is a bug...
> 
> ciao,
>   freddy77

Well, from ct_res_info help:

Retrieving the command number for the current result set

    * To determine the number of the command that generated the current
result set, call ct_res_info with result_typeas CS_CMD_NUMBER.

    * Client-Library keeps track of the command number by counting the
number of times ct_results returns CS_CMD_DONE.

....

Inside stored procedure or transactions, only select statements cause
the command number to be incremented. If a stored procedure or
transaction contains seven SQL commands, three of which are select
statements, the command number that ct_res_info returns can be any
integer from 1 to 3, depending on which select statement generated the
current result set.

...

If the command is one that executes a stored procedure or transaction,
for example a Transact-SQL exec language command or a remote procedure
call, ct_res_info returns either the number of rows returned by the
latest select statement executed by the stored procedure or transaction,
or CS_NO_COUNT if the stored procedure or transaction does not execute
any select statements. A stored procedure or transaction that does not
contain a select statement can execute a select by calling another
stored procedure or transaction that contains a select.


So it seem that even CTLib should ignore TDS_DONEIN_PROC is no columns
are present...

freddy77