Stored Procedure
Hallo
this is my stored procedure.
-------------------------------------------------------
create procedure pr_update_import()
define i,j INT;
TRACE OFF;
SET DEBUG FILE TO 'trace.out';
TRACE ON;
let j =3D 1;
foreach cur1 for select testschalter into i from import
if i > 100 and i < 1000 then
begin work;
update import set testschalter =3D j where current of cur1; commit work;
let j =3D j + 1;
end if
end foreach
trace off;
end procedure
----------------------------------------------------------
Two errors : 687 : Set debug file before tracing
If I leave the tracing :
255 : not in transaction=20
I have no answer !!
Thanks in advance
In der Hoffnung das Deutschland Weltmeister wird verbleibe ich,
mit freundlichem Gru=DF
Christian Hofinger
------------------------------------------------
Anwendungsentwickler Dresdner Bauspar AG
Tel. : 069 263 - 7830
EMail : Christian.Hofinger@dresdner-bauspar.com