Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Finding the cid after inserting into a VIEW
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00093685
Message ID:
00093752
Vues:
32
>>>I have a form where I create a history using an INSERT INTO a view. Immediately after doingt so I would like to store the cid that was created in the dbf file for later use. How might I go about doing that?
>>>
>>>Thanks.
>>
>>If your cid is generated in DBF you may REQUERY() your view to get ID assigned to INSERTed record, if it's what you mean.
>>
>>Nick
>
>Yes, but how can be sure that I am on the same record?

Well, if you have a parameterized view with one record (like me) it is not a problem, but if there are more you have to LOCATE your record after Requery().
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform