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:
00093861
Views:
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?

I recommend that you use the business object New() method to create a new record rather than using the INSERT INTO command. If the New() method successfully executes it calls the KBizObj.OnNew() method which prefetches a unique ID for you.

You should really do all data manipulation through the business object.

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform