The Module Extension
The UPDATE Statement
We place the phrase of the update SQL statement with all the possible fields:
|
<phrase name="UPDATE_T_ACCOUNT"> update t_account set login = '$login', description = '$description', dates_id = $dates_id, groups = $groups, owners = $owners where id = $id </phrase> |
The Class::Phrasebook::SQL will drop the "set" lines, where there is a placeholder that its value is undefined.
Ensure the update statements look as the example above - each "set" expression in different line.