No second result set is returned using multiple statements

Hi all

A contributor to OpenDBX pointed me to a problem which I tracked down to 
FreeTDS:

When sending two statements (a select and an insert statement) in a single SQL 
string to a MS SQL Server, FreeTDS only returns one result set for the select 
statement. If the same statements are reversed in the SQL string (first 
insert, then select), there are two result sets returned as expected, e.g.

INSERT INTO test (id,name) VALUES (1,'test1'); SELECT * FROM test
-> two result sets

SELECT * FROM test; INSERT INTO test (id,name) VALUES (2,'test2')
-> only one result set

I've also tested with libsybdb from Sybase ASE to be sure and it returns 
always two result sets.


Norbert
-- 
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc

_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEABECAAYFAkpA8loACgkQejn4xe4sRgVLeQCgsoZJomNvCDQbhn0y8LqGueAi
OwUAn3rmkd8Lx34kklMftiPYI7CLUs+L
=Op3W
-----END PGP SIGNATURE-----