mORMot Open Source

Geppy

Member

Registered: 2013-05-08

Posts: 6

CreateAndFillPrepareJoined parameters: any example?

Hi,

I'm trying to use TSQLRecord.CreateAndFillPrepareJoined() method to automatically create nested objects, but I don't understand the method parameters.
Neither in the whole Mormot documentation nor in the forum there is a complete and explicit example of this method.

In CreateandFillPrepare the SQL 'WHERE' clause with its parameters is easy to understand and straightforward.
In CreateAndFillPrepareJoined there are aFormatSWLJoin, aParamsSQLJoin and aBoundsSQLJoin parameters.
Do these mean that to call this method an explicit SQL JOIN clause is needed?
If yes, how should I write such clauses?
And if we must write explicitly the SQL JOIN instruction, doesn't it negate the concept of automatic nested object creation which should be the scope of this method?

Thanks.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,659

Website

Re: CreateAndFillPrepareJoined parameters: any example?

Afair the where clause parameters are appended to the join expression.