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.