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
Hi, It should sounds courious, but try to manually rewrite (ie., do not copy&paste!) your ZSQL method. MSSQL and Sybase servers are sometimes sensitive to unvisible characters and query does not work and you does not know why. ----- Original Message ----- From: Miguel Beltran R. 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
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
participants (3)
-
Dieter Maurer -
Jaroslav Lukesh -
Miguel Beltran R.