This is really very strange to me.
In my application, I have used many times in may modules something like as below for doing different different operations for specfifc needs.
Set RDORECORDSET = Nothing
Set RDORECORDSET = CONNECTION.OpenResultset("QUERY", rdOpenDynamic, rdConcurRowVer)
If (rdorspo2.AbsolutePosition = -1) Then //no records
..... do something
else // some records
..... do some other thing
It was working fine. But recently,
After my client complaints, I run the application based on his Database, and I saw that ::
After The NUMBER of records in A table increases beyond a particular Limit,
If (rdorspo2.AbsolutePosition = -1) Then
THIS IS NO WORKING. The Pointer Offcourse is at LAST Record ONLY becuase I printed the record, but absoluteposition is coming onwards as -1 only, though it should be last record number.
This is happening in all tables after NUMBER of records crosses a particluar LIMIT, YES different limits in Different Tables depending upon the Fileds/Fields Width of different tables.
Please explin me why this AbsoultePostion is giving worng values as -1 after movelast, as Records increases a LIMIT.