On Tue, Jun 9, 2009 at 6:30 PM, OpenDBX devel list <
libopendbx-devel@lists.sourceforge.net> wrote:
> 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 ':'
>
Sorry. This is totally my fault. A bad copy paste error :(
>
> 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
>
>
But my problem was with the other query. That query (insert before select)
works pefect for me. The one of the problem is (the select before the
insert):
SELECT * FROM alumno; INSERT INTO materia(codigo, nombre, observaciones,
id_alumno) VALUES (11,'Something', 'Nothing', 2)
did you tried this one also? If so and worked ok, would you mind sending me
your modified odbx-regression.h ?
Thanks a lot and sorry about the sintax error.
Mariano
>
> Norbert
> --
> OpenPGP public key
> http://www.linuxnetworks.de/norbert.pubkey.asc
>
>
>
>
> ------------------------------------------------------------------------------
> 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
>
>
------------------------------------------------------------------------------
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
