Retrieving the rows of a table

select@"select" Open the database and set the password, if one is required, and then issue the select command  <"select from" <table>
         〈"where" <where clause>〉
         〈"sort" 〈"by"〉 <sort clause>〉 via the "RIM" function. No column list is allowed as Rim always transfers complete rows.

Now you can "get" rows from this table, modify them and "put" them back, or "del"ete them. A prototype retrieval loop is illustrated in Figure [*]. Note that the character variables must be unpacked from the integer tuple array with "STRASC" and must be replaced with "ASCTXT".