FreeTDS Development Group

[Stefano Coletta <s.coletta AT uni.it>]

Hi Bill,
if you look back into the archives (not so far back) of this mailing 
list you have a trace log of the problem and the comments from any 
person who tried to give an interpretation of this behaviour. I have a 
test bed of this and I can try to apply your patches if it needs. I've 
even explain how to prepare a test bed without real servers.

Just search for my name as the sender.

And yes, Merge is the Multimaster replication of SQL Server.

Stefano Coletta

Unidata S.p.a.
Via Portuense, 1555 - 00050 Roma ( Ponte Galeria )
Tel +39 06650951
Fax +39 0665095002
E-mail s.coletta AT uni.it



Thompson, Bill D (London) wrote:

> Thanks Freddy, 
>
> I'll put this on my TODO.
>
> I've lost any memory I had of this issue/bug .
>
> Do we have a test case / program or a more detailed description of the issue
> ?
>
> merge publication seems to be something to do with replication ?
>
> Bill
>
>
>
>  
>
> > -----Original Message-----
> > From:   ZIGLIO, Frediano, VF-IT [SMTP:Frediano.Ziglio AT vodafone.com]
> > Sent:   23 January 2004 11:00
> > To:     FreeTDS Development Group
> > Subject:        RE: [freetds] News about this bug?
> >
> >    
> >
> > > > 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
> > _______________________________________________
> > FreeTDS mailing list
> > FreeTDS AT lists.ibiblio.org
> > http://lists.ibiblio.org/mailman/listinfo/freetds
> >    
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>