ADO - first record and last record only

[onressy]

after a record set is created is there an ADO record set parameter that one can use to get the last record value from a column as well as the first. i only need the First value and the last.

If i try to select the firts record and then use
objRS.MoveLast i get an error of: Rowset does not support fetching backward.

Do i really have to do two seperate queries?

Thanks

 

[Sheco]

No you can fiddle around with the recordset properties like CursorLocation, CursorType, and LockType.

The default recordset properties give you a forward-only "Firehose" cursor.

 

[Tarwn]

To extend that thought from Sheco: a static recordset (as opposed to forward-only, dynamic, or keyset) will let you read the first and then use MoveLast to hit the end record. The reason a Forward-only can't do a last is because it doesn't even know how many records it is holding. It strictly exists for you to ooop forward with MoveNext's.
Another option would be to use the GetRows method of the recordset object to dump the entire recordset into an 2-dimensional array. At which point you could access the data in any order and multiple times. This is probably overkill for what your currently trying to do though.