How To Save 2 TSQLRecord in the same time ?

bagusprasojo · 2016-10-05 02:50:52

Hi, I have 2 objects of TSQLRecord (TFahter and TChildren). I Want to save both in the same time. How should I do it ? How to define Transcation and commit ?

Thank You

Last edited by bagusprasojo (2016-10-05 03:02:45)

edwinsn · 2016-10-05 04:03:54

It's recommended to use "batch mode":

http://synopse.info/files/html/Synopse% … l#NDX_1604

When creating the TSQLRestBatch instance, supply 'nil' for the 'aTable' param.

Caveat: When calling Add/Delete/Update methods of it, don't forget to pass the correct 'TSQLRecord' subclass, otherwise it won't work **siliently** ( suggested @ab to raise exception in this case, but he don't agree .

bagusprasojo · 2016-10-06 02:21:36

Hi edwinsn thank you for your quick response.

I did it using "batch mode" also. But I got trouble when TFahter has property refers to TChildren. Everytime I save those objects, field Children in table TFather is always "0". I don't know how to use "batch mode" in this case.

Thanks

turrican · 2016-10-10 17:53:32

You need to do two transactions to achieve this. Because TSQLRecord.Add() needs to be commited to get the ID.

ab · 2016-10-10 18:07:22

You can force the ID, using an incremental integer on the server side, or TSynUniqueIdentifier if you want something unique over a network.

turrican · 2016-10-10 18:12:48

Nice idea AB!

bagusprasojo · 2016-11-10 04:58:59

ab wrote:

You can force the ID, using an incremental integer on the server side, or TSynUniqueIdentifier if you want something unique over a network.

Hi AB, how to Force ID if ID is readonly property ?

Thanks

Last edited by bagusprasojo (2016-11-10 04:59:25)

edwinsn · 2016-11-10 05:16:12

Try IdValue.

bagusprasojo · 2016-11-17 07:22:17

OK, Solved ! Thank you all

mORMot Open Source

#1 2016-10-05 02:50:52

How To Save 2 TSQLRecord in the same time ?

#2 2016-10-05 04:03:54

Re: How To Save 2 TSQLRecord in the same time ?

#3 2016-10-06 02:21:36

Re: How To Save 2 TSQLRecord in the same time ?

#4 2016-10-10 17:53:32

Re: How To Save 2 TSQLRecord in the same time ?

#5 2016-10-10 18:07:22

Re: How To Save 2 TSQLRecord in the same time ?

#6 2016-10-10 18:12:48

Re: How To Save 2 TSQLRecord in the same time ?

#7 2016-11-10 04:58:59

Re: How To Save 2 TSQLRecord in the same time ?

#8 2016-11-10 05:16:12

Re: How To Save 2 TSQLRecord in the same time ?

#9 2016-11-17 07:22:17

Re: How To Save 2 TSQLRecord in the same time ?

Board footer