Miguel Beltran R. wrote at 2008-12-1 11:13 -0600:
I have a zsql where made a UPDATE and INSERT, I need know when happen a error to show. I using pyodbc 2.0.58, zpyodbcda 1.0.6 and ms sql server 2000
[zsql with error after render: actualiza_info ] SET XACT_ABORT ON BEGIN TRANSACTION UPDATE taller SET comercial = '' where taller = 1
I would expect the need of a command separator (here at least and maybe after earlier commands as well).
insert into taller_movimiento (estado, taller, fecha, asunto, observacion ) values( '14', 1, '', <--This must be not blank '', '' ) COMMIT TRANSACTION
[dtml method] <dtml-try> <dtml-call actualiza_info> All Ok <dtml-except> Error, but not showed :( </dtml-if>
Omit the "dtml-try" (why does it end with "/dtml-if"?) and see whether you get more information. -- Dieter