Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing updatable tables in a View
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00122758
Message ID:
00123192
Views:
21
>But (there's always a but) when I need to create a new "Client" I have to insert the new record in the 3 tables. So, in the OnNew method of the main BizObj I called the .New() method of both "Client" and "Name" BizObjs. When I try to save the new record in the Main BizObj, I receive an error, because the insert trigger is triggered and there is no matching record in the "Client" table and in the "Name" table (not yet, they're going to exist when "Client" BizObj and "Name"BizObj are updated). Did you get the problem ?
>
>Regards,

If you have Main... and it has two children, Name and Client... you should set main and client to add records with lNewChildOnNewParent to true.

The user should enter the name and client info, then when they press save the parent and children will be saved.

If your _ri doesn't allow that to happen... I think you have to move the rules from the database to the bizobj. Not sure though, perhaps Kevin will jump in on this one.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform