Re: 2nd try: Problem with calling dbProcs in triggers

[Frank Peters]

hi
Jose Ignacio Carretero Guarde wrote:
Under Solaris 2.7 with SAPDB 7.3.0.29 I had some problems when I tried to
load the trigger, I solved them just naming evey table with the owner. I
mean:
create trigger AB_INSERT for test.A_B after insert execute (
var bname varchar(100);
begin
   call GETNAME(:NEW.ab_a_id, :bname);
   update test.a set a_b_name = :bname
   where a_id = :NEW.ab_a_id;
end;
)
And now it works ok.

Thanks, this really did the job.
BUT: only with v7.3.0.30 on linux.
7.4.3.10 on WinXP still has this problem - so im guessing that this is a 
bug in 7.4?
I will try this with 7.4 on linux just to verify - or is it a known one?

bye
frank


--
(-) Frank Peters
(-) SIGNAL 7 Gesellschaft f�r Informationstechnologie mbH
(-) Br�der-Knau�-Str. 79 - 64285 Darmstadt,
(-) Tel: 06151 665403, Fax: 06151 665373
(-) [EMAIL PROTECTED], www.signal7.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general