#1 2014-07-15 14:14:34

dbjulio
Member
From: Brasil
Registered: 2014-05-19
Posts: 2

Join with selected tables

Hi...

first of all, sorry for my english... I'm brazilian smile

we have a project with mormot, and we are impressed with the performance, congratulations smile

I have a question about the function CreateAndFillPrepareMany...

we have a class with three tables, they are linked using Pivot, TSQLRecordMany, etc., but I want to open only two tables using this function... how can I do this?

thanks.

Offline

#2 2014-07-15 19:22:05

ab
Administrator
From: France
Registered: 2010-06-21
Posts: 14,603
Website

Re: Join with selected tables

CreateAndFillPrepareMany() works only for 2 tables.
If you have three tables, you need to use your own SQL statement.

BTW, why did not you consider using sharding, and a document-oriented aggregate layout, using variant properties?
See the SAD 1.18 pdf about "many to many" relationship and data sharding.

Offline

#3 2014-07-16 11:34:56

dbjulio
Member
From: Brasil
Registered: 2014-05-19
Posts: 2

Re: Join with selected tables

we did not know that CreateAndFillPrepareMany only works with two tables.

I'll read about this in the SAD 1.18 and adapt my code.

thanks for the reply.

Offline

Board footer

Powered by FluxBB