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►