FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

James,

> Those "@@rowcount not available" indicate that dbnextresults() 
> is still returning something when the print packet arrives.  

dbnextresults() ????

> Does that duplicate the vendor libraries' behavior?  

Yes indeed... bsqldb compiled and linked with Sybase Open Client,
and run against a Sybase Database. Results:

---------------------
echo " print 'hi' select 'a' as a, 1 as one print 'bye'" | ./bsqldb
-U$DB_USER -P$DB_PASW -S$DSQUERY
Msg 5701, Level 0, State 2
Server 'LDNSYB1', Line 4
        Changed database context to 'ACCOUNTS'.
Msg 5703, Level 0, State 1
Server 'LDNSYB1', Line 4
        Changed language setting to 'us_english'.
Msg 0, Level 0, State 1
Server 'LDNSYB1', Line 1
        hi
@@rowcount not available
a          one
-  -----------
a            1
1 rows affected
Msg 0, Level 0, State 1
Server 'LDNSYB1', Line 1
        bye
@@rowcount not available
----------------------

HTH,

Bill


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: 05 January 2005 04:22
To: FreeTDS Development Group
Subject: Re: [freetds] [ freetds-Patches-1095806 ] patches for RC5


> Patches item #1095806, was opened at 2005-01-04 15:21
...
> Category: db-lib
> Group: None
> Status: Open
> Resolution: None
> Priority: 5
> Submitted By: Bill Thompson (thompbil)
> Assigned to: Nobody/Anonymous (nobody)
> Summary: patches for RC5
> 
> Initial Comment:
> here is my patch for RC5 as promised.
> 
> This patch fixes the following issues raised with 0.63 RC5
> 
> 1) dbsqlok eats too many end tokens
> 2) James' problem with PRINT statements
> 3) a small problem with CHAR/VARCHAR parameters in 
> dbrpcparam().

Applied to cvs HEAD, for now.  An improvement, clearly, but I'm not sure
it's exactly right.  

$ echo " print 'hi' select 'a' as a, 1 as one print 'bye'" | bsqldb -U$U
-P$P -S$S
Msg 5701, Level 10, State 2
Server 'test', 
        Changed database context to 'master'.

Msg 0, Level 10, State 1
Server 'test', Line 1
        hi
@@rowcount not available
a          one
-  -----------
a            1
1 rows affected
Msg 0, Level 10, State 1
Server 'test', Line 1
        bye
@@rowcount not available

Those "@@rowcount not available" indicate that dbnextresults() is still
returning something when the print packet arrives.  Does that duplicate
the vendor libraries' behavior?  

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds 
--------------------------------------------------------
 
If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/ 
--------------------------------------------------------