Page 1 of 1

ADO Absoluteposition

Posted: Mon Jun 18, 2007 11:43 pm
by Rick Lipkin
To All

I am running a roadblock and need to be able to store a recno to an array of 10 records. The only way I know how to update a record was to store the record number of the table in an element. WHen I go update the rows .. I just goto nRecno and Update my variables.

I do not have a problem getting a "suedo" record number with :

nRec := oRs:AbsolutePosition // -- get recno()
oRs:AbsolutePosition := nRec // -- goto nRecno

However since a recordset is not exactically a static commodity .. what are the pros and cons of using the above logic in moving between ( suedo ) records ??

Unforunitly .. creating a unique sequence id per record is not an option.

Thanks
Rick Lipkin
SC Dept of Health, USA

Re: ADO Absoluteposition

Posted: Tue Jun 19, 2007 11:59 am
by Enrico Maria Giordano
You can't use AbsolutePosition property across different recordset. The right solution is using an Id field (that you should have anyway).

EMG