What's moving the record pointer?

[jimstarr]

I'm calling a form, and in so doing, the record pointer is being moved, inappropriately.

To try and see what's going on I've put the statement

?RECNO()

immediately before the DO FORM and also as the first statement of the form's LOAD. The record pointer somehow changes before the LOAD. What are the possibilities? (VFP9)

Thanks!!!

Jim

 

[Mike Lewis]

Jim,

Does the form have a private data session? If so, is it possible that the form is re-opening the table in that data session? If so, the second RECNO() would always show the first logical record in the newly-opened table.

Also, are you sure that you are looking at the same table in both cases? As you know, RECNO() will report on the currently selected table. Do you see the same behaviour if you do ? RECNO("MyTableAlias")?

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[jimstarr]

I figured it out. It was not a private data session, but the table was being re-opened in the Data Environment. I never use DE's, but somehow this particular table was there. When I removed it, the problem disappeared. Thanks!


Jim