Reads a record from a native table, assigning the record to the specified variable.
Read variable From [table_var | Cursor cursorvar], key Then | Else statements
The Read statement has the following parameters.
|Variable||Assigned the value of the data that is read from the row specified by key.|
|Table_var||A table variable created by a previous Open statement.|
|Cursorvar||If accessing a cursor, cursorvar contains a cursor variable. Cursor variables are initialized with a Select...By statement and must be preceded with the word Cursor. If the table being accessed has had control features added, cursor access will automatically invoke domain conversion during a Read.|
|Key||The row referenced by key will be read from the table identified by table_var or the table accessed using the cursor in cursorvar.|
|Then||The statement(s) following Then are executed if a row key is read successfully.|
|Else||The statement(s) following Else are executed if the row in variable cannot be read. The Status() function indicates the severity of the error, and the system variable @FILE_ERROR contains details about the nature of the error.|