Zeoslib Portal

Good night

How to connect with Master-Detail Zeos?

Thanks,
Edson

Form1.test_Master_Detail;
var Master,Detail:TzQuery ds_Master:TDatasource;
Begin
try
Master:=TzQuery.Create(application);
Master.connection:=Zconnection1;
Detail:=TzQuery.Create(application);
detail.connection:=Zconnection1;
ds_Master:=TDatasource.Create(application);
Master.sql.text:='select * from master_table';
Master.OPen;
ds_Master.dataset:=Master;
detail.datasource:=ds_Master;
detail.sql.text:='select * from detail_table where linkField=:linkField';
detail.open;
{
Master and detail are now opened and linked perfectly. Enjoy!
}
finally Master.free;Detail.free;ds_Master.free; end;
end;

Hello mparak,

You can record the detail is a single transaction that is, to record the detail also the master record. How is the ClientDataSet?

Edson

Here the right code:
Regards Markus

mmvisual,

already implemented the above code, and is not yet possible to save master and detail in a single transaction.

elidorio2,

that is true an not supported from any component. If you use a Statement whitch joins the tables you need then you can use the TZUpdateSQL-Component and you can write all fields to all tables if your defined Statements are valid, Edson. But with a Master/Detail-Components it is not supported...

Michael

OK, Michael,
Zeos would be interesting to implement the Master / Detail, is equal to the ClientDataSet.
It is a very interesting feature that would look good on Zeos.

Edson

Hello,

I always use the form showed by mparak. The name of the detail parameter must be equals of the name of field in the master query.



Bye bye,

Josimar

josimarz,

i think that is not the purpose of elidorio2's second post. IF i understand him right then he want to Update the Master and Detail dataset in the same transacton if he uses tiReadCommited for example. Which means (i hope i do undestand him here right) if he says MasterQuery.Edit then the should the DetailQuery equal be updateable. And if he want to Post the updated row then both datasets should execute the update command in the same transaction session..

elidorio2, is that right what i think?

Michael

Btw. in mparak, post is the LinkedFields property missing so i don't think that anybody has success with his incomplete post. The post of mmvisual, is complete and should work.

Michael,
That's right, I want to run a single commit, which is saved in the database, the master and detail in a single transaction.
example:
1 - Insert the data from the master
2 - I insert data items, for example 5 item
3 - It is to save in a single commit, save the master and detail of the five items.

Edson

elidorio2,

Can you prepare me a test-case? You can use the bug-template or. Make me a test ready which i can add to the test suites. Then we have a reminder and can solve your requests...

Michael