Hi Mariano > Norbert: I get multistatments working with all the backends except MSSQL. I > have a problem with it. > > If I enable multistatements and execute something like this: > > INSERT INTO materia(codigo, nombre, observaciones, id_alumno) VALUES (11, > ''Something'', ''Nothing'', 2)'; select := 'SELECT * FROM alumno' > > I have no problems. OpenDBX give me first a resultset for the update and > then the other for the select.
I tested this by extending a mssql statement in test/odbx-regression.h and got an syntax error back from the MS SQL Server: Incorrect syntax near ':' When I use statements like this, everything is OK: INSERT INTO materia(codigo, nombre, observaciones, id_alumno) VALUES (11, 'Something', 'Nothing', 2) SELECT * FROM alumno Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects
_______________________________________________ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
