>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