Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding the cid after inserting into a VIEW
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00093685
Message ID:
00093752
Views:
31
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform