◄Summary►  ◄Details►  ◄Example►                ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
 UPDATE [#]filenumber%, recordvariable
 
 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 have
     made. See: ◄RETRIEVE Statement►
 
   ■ Use INSERT to add a record to a table without overwriting the current
     record. See: ◄INSERT Statement►
 
   ■ If the values passed to recordvariable do not match the record structure
     in the user-defined type, Visual Basic generates the error message,
     "Type mismatch." The record structure includes the names and types of
     columns or fields.
 
   ■ Visual Basic removes trailing spaces from strings used in an update.
 
   ■ DELETE, INSERT, and UPDATE operations affect all indexes in a table.
     Each of these operations automatically updates all indexes. INSERT or
     UPDATE will fail if the operation produces a nonunique index value in
     any index defined as unique-only. DELETE, INSERT, and UPDATE operations
     are not affected by SETINDEX.
     See: ◄DELETE Statement►    ◄INSERT Statement►
          ◄SETINDEX Statement►  ◄UPDATE Statement►