Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record Pointer Moving after REQUERY
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00290073
Message ID:
00290165
Vues:
22
Rich,

Your problem may be similar to one I was having. Try the following:

=REFRESH()
GO RECNO()

HTH

>Bob,
>
>Thanks I just needed to be slapped! Well, I was trying to get the ID value that was generated by my Stored Procedure code back into my View record.
>
>It doesn't retrieve it from the Refresh(). So I was doing a Requery() as well but retrieves all records again since currently I am pulling in all records for Local Views for single table edits. I am contemplating one record for the future but I will have to change all of my navigation code to support it in my forms.
>
>How should I get back my new ID that was generated?
>
>TIA
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform