ADO Absoluteposition
Posted: Mon Jun 18, 2007 11:43 pm
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
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