sql statment for the record postion

[j_lyver]

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.

[Clunietp]

You can retrieve the record position by a property of your DAO/ADO recordset.recordcount property -- not by using SQL commands