mORMot Open Source

@edwinsn
Thanks, I can try option 2.
I want to have an easier way. How do you solve this problem?

Sorry. I still have some problems. I am using server-side transaction. I tried two ways, both have problems.

aRestServer.TransactionBegin(nil, 0);
try
  aRestServer.Add(aMasterRecord, True);
  aDetailRecord.MaserId := aMasterRecord.AsTSQLRecord;
  aRestServer.Add(aDetailRecord, True);
  aRestServer.Commit(0);
except
  aRestServer.RollBack(0);
end;

In this way i can get and set the MasterId property.
But After aRestServer.Add(aMasterRecord, True),  data has been written into database already. Commit and RollBack won't do nothing.

aSQLRestBatch.Add(aMasterRecord, True);
aSQLRestBatch.Add(aDetailRecord, True);
aRestServer.BatchSend(aSQLRestBatch, Res);

In this way, transactions works fine. But I don't konw how to set aDetailRecord.MasterId property.

The real problem is that I want use transactions in the Master/Detail situation, and set Master/Detail relationship correctly.
Any help?