The open method procedure of the recordset object type is used to open a recordset. In order to call this method you need a recordset object reference, a connection object reference to open connection object, as well as the SQL statement which will return the recordset or recordsets, that will be referenced by the open recordset object.
The code fragment below show a typical use of a recordset. NOTE: The code fragment is not a complete program and makes the following assumptions:
new(rs);
rs.open(conn, 'select last_name, first_name from customer', rsforward);
while not rs.eof
begin
writeln(rs.field('last_name'), ', ', rs.field('first_name'));
rs.movenext;
end;
rs.close;
dispose(rs);
Operating Systems: All
Standard Pascal: No