Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What's moving my Recno() ?
Message
De
04/01/1998 19:40:22
 
 
À
04/01/1998 11:47:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00069341
Message ID:
00069413
Vues:
46
>Something keeps moving my record pointer after a seek back to where it started (or maybe just to the top of the
>table, since it always starts at the top).
>
>I put these two statements in the method where it happens.
>
>    wait window str(recno('clients'))        && shows correct seeked record
>    wait window str(recno('clients'))        && shows record 1 (record before seek)
>
>
>There are NO statements between the 2 wait windows, but the recno() changes.
>
>I can't even begin to figure out what's doing it, so I don't know what info might help someone else figure it
>out.
>
>The only thing I can even imagine might have something to do with it is the relations:
>(I'm leaving out all the normal syntax, just to show you the relations)
>
>select table2
>set relation into table3
>set skip to table3
>
>select clients
>set relation into table2
>set skip to table2, table3
>
>

Further Info

I have included this code in the method that keeps reverting the Recno(), and now it works fine.
I cut and pasted these line from my VFP window, just so there is no chance of typo. They are EXACTLY as they
appear in my code. (Just in case you still don't believe me, I acknowledge that these 3 lines accomplish
NOTHING ---- except make the procedure work properly).
          lnRecno = RECNO()
          WAIT WINDOW '' TIMEOUT .001
          GOTO lnRecno
If I comment out these 3 lines, or just comment out the "wait window" line,
then somehow Recno() goes back to record 1 at the location where these 3 lines are inserted.

I have definitely determined that prior to the "wait window" Recno()=lnRecno (not 1), but after the
"wait window" Recno()=1.

Can someone explain this?

Bill
Bill Morris
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform