Hi list<br><br>I have a zsql where made a UPDATE and INSERT, I need know when happen a error to show.<br>I using pyodbc 2.0.58, zpyodbcda 1.0.6 and ms sql server 2000<br><br>[zsql with error after render: actualiza_info ]<br>
SET XACT_ABORT ON<br>BEGIN TRANSACTION<br>UPDATE taller SET<br> comercial = ''<br>where taller = 1<br>insert into taller_movimiento (estado, taller, fecha, asunto, observacion<br>) values(<br> '14',<br>
1,<br> '', <--This must be not blank<br> '',<br> ''<br>)<br>COMMIT TRANSACTION<br><br><br>[dtml method]<br><dtml-try><br> <dtml-call actualiza_info><br> All Ok<br><dtml-except><br>
Error, but not showed :(<br></dtml-if><br><br><br>If I test the zsql show this, but must show the error:<br><br>This statement returned no results.
<hr><strong>SQL used:</strong><br>
<pre>SET XACT_ABORT ON<br><br>BEGIN TRANSACTION<br><br>UPDATE taller SET<br> comercial = ''<br>where taller = 1<br><br>insert into taller_movimiento (estado, taller, fecha, asunto, observacion<br>) values(<br> '14',<br>
1,<br> '',<br> '',<br> ''<br>)<br><br>COMMIT TRANSACTION<br><br></pre><br clear="all"><br>-- <br>________________________________________<br>Lo bueno de vivir un dia mas<br>es saber que nos queda un dia menos de vida<br>