| Subject | Re: order by on different way |
| From | Dirk <non@non.com> |
| Date | Sat, 20 Nov 2021 21:52:45 +0100 |
| Newsgroups | dbase.getting-started |
| Attachment(s) | taal.zip |
Op 20/11/2021 om 21:02 schreef Mervyn Bick: > On 2021/11/20 14:28, Dirk wrote: > >> Mervyn, >> >> i think i mis explained >> >> in the meantime i know using the mastersource has a quit different >> approach as masterfields/masterrowset >> >> i you have look on the text file i am just wondering if to save the >> link the child query (contact) to the master query ( firam) has been >> done on a proper way >> >> the annex form is also used on different place in the programm to be >> able adding and modify contacts >> >> thanks again >> Dirk > > I can't run or even open your forms in the designer as I don't have the > necessary tables. It is, therefore, difficult to get the "big picture". > I do however, have some concerns. > > All the controls in custview.wfm are datalinked to the either the rowset > for vraagbak_contact or vraagbak_Firma in custview.wfm. > > For new child records KNOP_AANMAKEN_onClick() adds a blank record to the > rowset for vraagbak_kontakt in the parent form stamcucst.wfm. Nowhere > is this new record saved explicitly. If you don't save the record when > the custview form returns control to the stamcust form you are relying > on an implicit save which is made when vraagbak_kontakt is navigated. If > stamcust.wfm is closed without changing the selection in the parent > table the last record added or changed in vraagbak_kontakt will be lost. > > The event handlers for the DELETE, ABANDON and SAVE buttons all execute > methods of the vraagbak_contact rowset in custview.wfm. > > New child records should be added to vraagbak_contact in custview.wfm. > When control is returned to stamcust.wfm requery() vraagbak_kontakt to > make any changes to the communicate table available in stamcust.wfm. > > The function form_onNavigate(nWorkArea) is redundant as you are using > OODML query objects. This would only be executed if you were using XDML > to open tables in workareas i.e USE tablename > > Mervyn. > Mervyn some files to analyze Dirk | |