Page History

Updates columns in a columnized table.
*Note:* In import scripts the update command must be enclosed in brackets \{\}
Syntax:
UPDATE table_to_update from_alias \[LEFT JOIN|INNER JOIN table_to_update_with join_alias\]
    set amount=amount*100,
  somecolumn=join_alias.somecolumn_in_alias
WHERE from_alias.somecolumn is null
\{UPDATE Customers SET CustName='Schmitt', City='Hjorring' WHERE CustNumber=2134\}
\{
UPDATE fInvoiceLines a left join dInvoiceHeaders b on a.Company=b.Company and a.\[DocNo\]=b.\[DocNo\]
 set wPricesIncludingVAT = b.\[Prices Including VAT\]
 where b.\[Prices Including VAT\]=1\}
\}
 \\