0

I am using a data control with a simple SQL statement. I am accessing the Data1.Recordset.RecordCount property right after I call Data1.Refresh and I noticed it was giving me incorrect results (It would say there were 20 records, when there were actually 85). The weird part is, I put a break on the line where I try to get the record count, and when I mouse over it to see the value, it says 20, but if I wait 5-10 seconds, it changes to the correct value of 85. How would this value be changed while the program is in debug mode, on the line break? This is very confusing to me and I am unable to find any information on it.

2
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by QVeen72
0

Hi,

After refresh do some move operation like "Data1.RecordSet.MoveLast" and then check the RecordCont, it will display properly..

REgards
Veena

0

Thank you, a MoveLast and MoveFirst makes it work correctly, however I can't help but remain curious as to how a variable can change while program execution is halted on a breakpoint...

0

Hi,

Does the Table u Query Have More Records >= 1 lakh...? or u r using a Join on 2 Tables without proper link and is it returning large number of rows..?

REgards
Veena

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.