[Zope] ODBC and SQL INSERT

Martijn Pieters mj@antraciet.nl
Mon, 30 Aug 1999 08:55:53 +0200


At 21:41 29/08/99 , Klement J. Fellner wrote:
>hello zopisti,
>
>one major problem:
>everything functions with delight... only the insert
>statement does not work. it looks like it did work
>in the zope environment, but if I look directly at the
>database, no rows are inserted.
>oh... what we use: Zope 2.0b5 with Oracle ODBC
>on windows NT. The ODBC driver is functioning.
>
>are there any known issues when using ODBC??

Yes, the ODBC DA has not yet been updated to Zope 2.0, and no transactions 
are committed yet. You won't notice this with SELECT, but you sure will 
with INSERT, UPDATE, DELETE and other state altering statements.

--
Martijn Pieters, Web Developer
| Antraciet http://www.antraciet.nl
| Tel: +31-35-7502100 Fax: +31-35-7502111
| mailto:mj@antraciet.nl http://www.antraciet.nl/~mj
| PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149
------------------------------------------