update statement

Applications Forms
#1

Hi,

​I have a table - product with the following data:
product A
product B
…

​When I change the product name using form application. eg. product A to product AAA

​I need to update my other table that has the name “product A”.

​May I know how should I input the where clause for the sql?
Below is hardcoded where clause.

sc_exec_sql(“update product set name=’{name}’ where name=‘product A’”);

Previously, I use PHPRunner, there is something like the following:
[LEFT][SIZE=13px]update product set name=’{value}’ where name=’{old_value}’;[/SIZE][/LEFT]

#2

You can update it in event onafterupdate. can use the macro sc_exec_sql. in clause WHERE you can use same code of product. If both tables have the code like primary key.