advr.hlp (Topic list)
Important Notice
The pages on this site contain documentation for very old MS-DOS software, purely for historical purposes. If you're looking for up-to-date documentation, particularly for programming, you should not rely on the information found here, as it will be woefully out of date.
UPDATE Statement Details
  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