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.
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.