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