Multiple Insert-updates

Data Abstract
1

Hello, I am having a problem with a project and need help.
I have a master detail relation between 1 master table to 3 detail tables.
The detail records are bind to a TMSFmxGrid.
The autoinc field and Foreign keys fields are properly updated on every new record of the detail tables, and on some strange situations, when Applyupdates on the master table, the system gives me ‘Record pointer changed’.
What am I doing wrong? I just ‘Post’ the main table, and then sometimes i get the above message.
Please advise.

2

Hello again. Some more information conserning the problem.
Its Delphi XE3, with Firemonkey2, and i have sample code to send you, in case you want to investigate.In fact, the sample code, its your MasterDetail sample on Dataabstract samples, but its converted to firemonkey with TStringGrid. The problem occurs when one edits a detail record, and uses the mouse to navigate elsewhere on the grid. In case one edits a detail record, and scrolls to previous on nest record, the problem does’t occur. Hope that helps you.
Best regards.

3

Hello,
What DA version do you use? Can you send us a small testcase which reproduces this error?

4

Hello, and thank you for the reply.
The DA version is 7.0.65.1067, on win 7, Delphi XE3 ,firemonkey 2
I have a small test case to send, which -as I explained on my comment, is a modified copy of your Master Detail sample of Dataabstract samples.
The only difference, is on orders detail grid, i have an exit event assigend, in order to push the post command on an update on the grid. Same thing happens on your Master Detail sample, but the post is triggerd by the TDBGrid.
In any case, if you edit a order detail field on the grid, and then change the record position on the grid with the mouse, the Record change message rise.Same situation, work fine on vcl.
Thank you again for your time.
Best regards.

5

Hello,
TStringGrid doesn’t generate changing position event when you move to another string in FMX.
Perhaps it’s a bug in FMX. This situation occurs also with native ADO and CDS.

The following code without Grid works fine:

begin
  tbl_Clients.Open;
  tbl_Clients.Edit;
  tbl_Clients.FieldByName('ContactAddress').AsString := 'Address 1';
  tbl_Clients.Post;
  tbl_Clients.Next;

  tbl_Clients.Edit;
  tbl_Clients.FieldByName('ContactAddress').AsString := 'Address 2';
  tbl_Clients.Post;
  tbl_Clients.Next;

  tbl_Clients.Edit;
  tbl_Clients.FieldByName('ContactAddress').AsString := 'Address 3';
  tbl_Clients.Post;
  tbl_Clients.Next;

  tbl_Clients.ApplyUpdates;
end;
6

Hello, and thank you for the reply.
So, there is no way to edit on grid. The example you gave me, is already working for me. Problem is, editing on a grid, for multiple records editing and posting. Any suggestion?

7

Hello,
You should call Post manually after editing record to save data. You can change your records in separated form with Post and Cancel button.
You can also use VCL dbgrid.