mORMot Open Source

Thank you, for the reply. I just started to read and test this framework;

After reading the section you suggested, I am trying to use the TSQLRecordMany to get the relationship between the two tables; If I am understanding correctly, it uses a pivot table to do it.

I will use here a simple example, what I want is to understand the correct way to get this relationship working;

So I created three classes, to make the tests.

TPerson(TSQLRecord)
TPhone(TSQLRecord) and
TPhones(TSQLRecordMany)

Then I created a published property in TPerson like this:

property Phones: TPhones read FPhones write FPhones; //TPhones is descending from TSQLRecordMany

But when I use this procedure of TPerson:

procedure TPerson.InsertPhone(IDDI,IDDD,INumber : Integer) ;
var phone : TPhone;
begin

   Phone:= TPhone.Create;
   Phone.ddi := Iddi;
   Phone.ddd := Iddd;
   Phone.numero := INumber ;
   
  if Telefones.ManyAdd(Database.client,self.ID,phone.ID,true,nil) then ////This Method ManyAdd is failing, (returning false)

showMessage('Method returned true') else
showMessage('Method returned false');

end;

So, what is the correct way to use it?

======================================

If I use a TObjectList as a property in a TSQLRecord class, I get a blob JSON in the database table, but what I want is each of these objects may be stored inside its own table, and not as a blob field.