zapping - Thursday, May 13, 2010 1:53 PM:
Hi All,
I would like to perform something like a cascade edit to parent/child tables. i have added a code field to manufacturer table or itemtype and created a manufacturer_alias table or itemtype that also has code which referrers to the manufacturer table. If the manufacturer code gets edited then the corresponding codes in the manufacturer_alias should also be edited.
Have created an OnAfterUpdate server event for the manufacturer itemtype with a method ChangeCodes. In the method wrote this query.
UPDATE manufacturer_alias SET code='" + this.getProperty("code") +"' WHERE code='" + old_code +"'"
But not sure how to get the old_code value for the query.
Cheers,
Zaps
zapping - Monday, May 17, 2010 12:54 PM:
Solved it. This post helped a lot. www.aras.comhttp:/.../2390.aspx
thx.
