Hi list

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
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>

If I test the zsql show this, but must show the error:

This statement returned no results.

SQL used:

SET XACT_ABORT ON

BEGIN TRANSACTION

UPDATE taller SET
  comercial =  ''
where taller = 1

insert into taller_movimiento (estado, taller, fecha, asunto, observacion
) values(
  '14',

  1,
  '',
  '',
  ''
)

COMMIT TRANSACTION

--
________________________________________
Lo bueno de vivir un dia mas
es saber que nos queda un dia menos de vida