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.
RETRIEVE Statement Details
◄Summary► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
RETRIEVE [#]filenumber%, recordvariable
Usage Notes
■ The values passed to recordvariable must exactly match the field types
in the user-defined type.
■ The argument recordvariable is the name of the variable that will hold
the current record's data. It is a variable of the user-defined type
tabletype that was specified in the OPEN statement.
■ RETRIEVE places the current record's data into recordvariable. You can
change the data in recordvariable, then update the current record with
the changes you've made.
■ Use the UPDATE statement to update the current record.
See: ◄UPDATE Statement►
■ Retrieve has no effect on the current position.
■ 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.