As I say, I avoid using data aware control based development myself, but I do have to work with projects that employ this approach (the problems routinely encountered in doing so doing nothing to assuage my antipathy for the approach).
One thing I notice absent from your description of your code is that you don't mention ever calling ApplyUpdates(). Insert/Append -> Post operate on the dataset, but to have your changes applied to the *underlying datasource* you need to *apply* those dataset changes. If that is your issue in this case then it is worth nothing that this isn't a DevArt issue specifically, but rather a part of the entire TDataset based approach, aiui. So you will run into the same complications with *any* dataset based framework. On 28 June 2015 at 17:51, Marshland Engineering <[email protected]> wrote: > I have used MYSQL as it is Delphi/PHP etc friendly, however, with Devart > components, I'm really pulling my hair out. > > Maybe I'm not using the bits as Devart expected, but I'm using standard > Delphi > language. > > I found a new issue. > > In my main form I have an option to add a new record, > > if MessageDlg('Add member ?',mtConfirmation, [mbYes, mbNo], 0)= mrYes then > begin > dm.tblMaster.Append; > fMembers.ShowModal; > > In the child form, which is called from a few other options, I have a > record > refresh to ensure I have the latest data in a multiuser environment, > > procedure TfMembers.FormShow(Sender: TObject); > begin > dm.tblMaster.RefreshRecord; > dm.tblClubMemMast.RefreshRecord; > dm.tblMaster.Edit; > > However, my newly appended record is now gone and I'm positioned on another > valid record. > > Do I persist with Devart and learn all the oddities or try something else ? > > Any suggestions please. > > Thanks Wallace > > > > > > -- > Thanking you > Wallace Weideman > Marshland Engineering > 704 Marshland Road > Styx > Christchurch > 03 3237449 > www.marshland.co.nz > > On 26/06/2015 at 12:00, [email protected] wrote: > >Send Delphi mailing list submissions to > > [email protected] > > > >To subscribe or unsubscribe via the World Wide Web, visit > > http://listserver.123.net.nz/mailman/listinfo/delphi > >or, via email, send a message with subject or body 'help' to > > [email protected] > > > >You can reach the person managing the list at > > [email protected] > > > >When replying, please edit your Subject line so it is more specific > >than "Re: Contents of Delphi digest..." > > > > > >Today's Topics: > > > > 1. RE Relationship or not (Marshland Engineering) > > 2. Re: RE Relationship or not (Jolyon Smith) > > > > > >---------------------------------------------------------------------- > > > >Message: 1 > >Date: Thu, 25 Jun 2015 22:41:04 +1200 > >From: "Marshland Engineering" <[email protected]> > >Subject: [DUG] RE Relationship or not > >To: [email protected] > >Message-ID: <[email protected]> > >Content-Type: text/plain; charset=UTF-8 > > > >Hi chaps and update. Barry, Eric and Alistair all came to the rescue and I > >learned something from each one. Thanks very much. > > > >I'm using Devart for Mysql access. > > > >So what I have learned is, that, if you have a Master Detail relationship > and > >you do a post with the Master table, the Detail table changes from edit to > >browse mode all by itself. !!!! > > > >Along the same lines if you have a Master Detail relationship and look to > see > >if there is a Detail entry for a Master record and there isn't one, when > you > >put the master into edit mode, it automatically creates one for you (or a > >virtual one) in the detail form so any conditional statement with the > Detail > >table now returns true. > > > >So with Devarts components- things happen behind the scenes which can be > hard > >to find. > > > >Thanks Wallace > > > > > > > >------------------------------ > > > >Message: 2 > >Date: Fri, 26 Jun 2015 07:59:33 +1200 > >From: Jolyon Smith <[email protected]> > >Subject: Re: [DUG] RE Relationship or not > >To: NZ Borland Developers Group - Delphi List > > <[email protected]> > >Message-ID: > > < > calxexoqv-avcm+vdtt4a_bzt51ahwvhbhebn81pxnpze8mc...@mail.gmail.com> > >Content-Type: text/plain; charset="utf-8" > > > >"things happen behind the scenes which can be hard to find" > > > >In my experience this holds true for *any* component based, drag-and-drop > >development approach. DevArt components are no different in this respect > >than any other framework. > > > >That, and the fact that program behaviours are driven, sometimes subtly > and > >sometimes significantly, by minor variations in component properties that > >are immeasurably more difficult to discover than changes resulting from > >difference in actual code, is why I avoid using such frameworks for > >application development like the proverbial. > > > >You can create an app that works (or seems to) very quickly. But when > >problems arise or you need to change or extend the behaviour or implement > >something which doesn't fit with the way that the components you are using > >expect or intend you to, the effort involved (and unintended side effects > >arising) then can be disastrously disproportionate. > > > >imho > >ymmv > > > >On 25 June 2015 at 22:41, Marshland Engineering < > [email protected]> > >wrote: > > > >> Hi chaps and update. Barry, Eric and Alistair all came to the rescue > and I > >> learned something from each one. Thanks very much. > >> > >> I'm using Devart for Mysql access. > >> > >> So what I have learned is, that, if you have a Master Detail > relationship > >> and > >> you do a post with the Master table, the Detail table changes from edit > to > >> browse mode all by itself. !!!! > >> > >> Along the same lines if you have a Master Detail relationship and look > to > >> see > >> if there is a Detail entry for a Master record and there isn't one, when > >> you > >> put the master into edit mode, it automatically creates one for you (or > a > >> virtual one) in the detail form so any conditional statement with the > >> Detail > >> table now returns true. > >> > >> So with Devarts components- things happen behind the scenes which can be > >> hard > >> to find. > >> > >> Thanks Wallace > >> > >> _______________________________________________ > >> NZ Borland Developers Group - Delphi mailing list > >> Post: [email protected] > >> Admin: http://delphi.org.nz/mailman/listinfo/delphi > >> Unsubscribe: send an email to [email protected] with > >> Subject: unsubscribe > >> > >-------------- next part -------------- > >An HTML attachment was scrubbed... > >URL: > > http://listserver.123.net.nz/pipermail/delphi/attachments/20150626/4356b1f0/attachment-0001.html > > > >------------------------------ > > > >_______________________________________________ > >Delphi mailing list > >[email protected] > >http://listserver.123.net.nz/mailman/listinfo/delphi > > > >End of Delphi Digest, Vol 140, Issue 12 > >*************************************** > > _______________________________________________ > NZ Borland Developers Group - Delphi mailing list > Post: [email protected] > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to [email protected] with > Subject: unsubscribe >
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
