hi,
while writing an update trigger for 7.4.3 build 007-000-030-320 i wanted to
use the following code:
try
update <table> set <some int column> = 3 where <key> = <something>
ignore trigger;
update <same table> set <some other int column> = 3 where <key> =
<something else> ignore trigger;
catch
if 100 = $rc then
continue execution;
else
stop(3, $errmsg);
but while creatation it throws
[SAP AG][SQLOD32 DLL][SAP DB]Syntax error or access violation;-5015
POS(1866) Missing keyword:EXECUTE.
SQLSTATE = 37000
at the keyword execution.
i wanted the code to perform both statements only if $rc = '100 no row
found'
am i using this correctly?
thanx in advance,
John Holland
Consultant
BANCOTEC
Ein Unternehmen der Cellent AG.
Calwer Strasse 33, 70173 Stuttgart
Tel: ++49 711 222 992 900
Fax: ++49 711 222 992 999
Mobile: ++49 172 7886719
mailto:[EMAIL PROTECTED]
http:\\www.bancotec.de
http:\\www.cellent.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
