>Now I get error # 1547 "Cannot insert or empty row from a view into its base table(s)."
>
>The form has a business object as well as the kmovermoverobj. The error occurs in the requery method of the form bizobj. I have traced thru the code. kbizobj.requery() is the default method. The alias is correctly being selected.
>lnRetVal = this.oBehavior.Requery() causes ctablebehavior.requery() to execute. It is here that it executes lnRetVal = REQUERY() with immediately causes the error. I have tried opening the database, opening the view and executing REQUERY() and it works just fine.
>Can you please guide me?
Visual FoxPro typically gives you this error if there is a new record in your view when the BizObj.Requery() is executed.
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