I have the a record postion of a table, but what i need is from that postion i need to select all the row that corresponds to the postion.
Thanks a lot
Printable View
I have the a record postion of a table, but what i need is from that postion i need to select all the row that corresponds to the postion.
Thanks a lot
Maybe I don't know what you mean, but the select statement for all of the attributes (fields) within a row is "SELECT TABLE.* from TABLE for <condition>"
The asterik (*) selects all attributes within the table. You can then ask for them by name like TABLE.FIELD1, TABLE.FIELD2, etc.
You can retrieve the record position by a property of your DAO/ADO recordset.recordcount property -- not by using SQL commands