Insert Or Update Field Code. This results in your querying for the record first to determine if it exists before performing the appropriate operation. In a document you have open right-click a field such as a table of contents a page number or a cross-reference and click Update Field.
Do this so the field code isnt updated any more. Calls the respective INSERT UPDATE or DELETE statements for each inserted updated or deleted row in the specified DataSet from a DataTable named Table public. You can update fields one by one or you can update all the fields in your document at once.
Add - Edit Delete buttons from the command field and check on the auto generate fields.
However if you specify the ON DUPLICATE KEY UPDATE option in the INSERT statement MySQL will update the existing row with the new values instead. If your document has tables with fields or formulas you might need to select each table separately and press F9. The UPDATE statement can modify one or more records and generally takes this form. Instead press CtrlF9 and then key in the code within the brackets.
