[ic] Update two tables?

DB db at m-and-d.com
Sun Mar 5 17:20:55 UTC 2023


I'm able to update fields in one table using for example

[set mv_data_enable]1[/set]
[tag flag write]orderline[/tag]

<FORM METHOD=POST ACTION="[process]">
<INPUT TYPE=HIDDEN NAME="mv_data_table"    VALUE="orderline">
<INPUT TYPE=HIDDEN NAME="mv_data_key"	   VALUE="code">
<INPUT TYPE=HIDDEN NAME="mv_data_function" VALUE="update">
<INPUT TYPE=HIDDEN NAME="mv_nextpage"     VALUE=@@MV_PAGE@@>
<INPUT TYPE=HIDDEN NAME="mv_data_fields" VALUE="code, notes">
...

How would I update two tables at once, say orderline and transactions 
where both have a primary key called "code" ?

DB


More information about the interchange-users mailing list