Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record pointers on empty cursors/tables
Message
De
02/02/2004 09:32:48
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
À
02/02/2004 09:27:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00872917
Message ID:
00872923
Vues:
23
Yeah, that's pretty much what I thought I would have to do... So, I guess the real issue is that RECNO() is NULL if the table is empty? It has no actual value? Hmmm... I could see cases where RECNO() could be -1 though in the case of added records in a buffer. Maybe the best way would be to check if nRecNo is NULL rather than > 0.

>Hi Jay
>
>This modification should do the trick:
>
>cAlias = ALIAS()
>
>nRecNo = RECNO()
>
>Do Something
>
>SELE (cAlias)
>
>IF nRecNO>0
>   GOTO nRecNo
>ENDIF
>
>
>>I use the following code in numerous methods to keep record pointers where they belong
>>
>>
>>cAlias = ALIAS()
>>
>>nRecNo = RECNO()
>>
>>
>>Do Something
>>
>>
>>SELE (cAlias)
>>
>>GOTO nRecNo
>>
>>
>>But if the ALIAS was empty then the GOTO will give a record out of range error. Often the Do Something code is using tables/cursors, etc and the goal is to leave open data the same when exiting a method as it was on entering. Any thoughts? Thanks!
>>
>>Regards, Renoir
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform