Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple New Children on Add New Parent
Message
From
12/04/2001 16:45:02
 
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00494819
Message ID:
00495065
Views:
17
>Hi Alex,
>
>Its one parent table and a one child table.
>
>Here's the genreal setup for info
>
>TABLE A is parent to TABLE B and TABLE X
>
>TABLE B is parent to TABLE C. A surrogate PK, FK to TABLE B, and some entry data.
>
>TABLE X contains the default values for TABLE A
>
>TABLE C contains the user modifed default values. A surrogate PK, FKs to TABLE B and TABLE X, and the modified default.
>
>
>I have it somewhat working by querying the child table with the new parent key value, result is empty, then I requery a view that has the defaults, cycle throught that defaults view calling the NEW() of the child BizObj and replacing the with the default values. Only problem in this method is when I display the child records for the user its at the bottom of the file and any attempt to move the record pointer to the top prior to the display causes the cannot insert empty rows into base table errror.
>
>I thought about the new method as well but for somereason rejected it....maybe worth investigating it again.
>
>
>Thanks for the reply.

I wouldn't tinker with the bizobj itself, but there is an object that may be suited for this. The event object can handle the cordination between the tow bizobjs quite nicely, and is designed for just such a purpose. Check the Developer's Guide.

Jim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform