◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
UPDATE adds an updated record to an ISAM table, overwriting the current
record.
 
UPDATE [#]filenumber%,recordvariable
    ■ The argument filenumber% is the number used in the OPEN statement
      to open the table.
    ■ The argument recordvariable is a variable of the user-defined type
      corresponding to the table. It is the record that will overwrite
      the current record.
 
Usage Notes
    ■ UPDATE replaces the current record with recordvariable. It remains
      the current record.
    ■ Use RETRIEVE to fetch the current record and place its data into
      recordvariable. You can change the data in recordvariable, then use
      the UPDATE statement to update the current record with the changes
      you've made.
    ■ Use INSERT to add a record to a table without overwriting the
      current record.
    ■ If the values passed to recordvariable do not match the record
      structure in the user-defined type, BASIC generates the error
      message, "Type mismatch." The record structure includes the names and
      types of columns or fields.
    ■ BASIC removes trailing spaces from strings used in an update.