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.

  ◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
RETRIEVE fetches the current record in an ISAM table and places its data into
a record variable.
 
RETRIEVE [#]filenumber%,recordvariable
    ■ The argument filenumber% is the number used in the OPEN statement
      to open the table.
    ■ 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.
 
Usage Notes
    ■ 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.
    ■ 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, BASIC generates the error
      message, "Type mismatch." The record structure includes the names
      and types of columns or fields.