Zeos 7, Master/Detail problem

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
NilSer
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 03.08.2009, 21:15

Zeos 7, Master/Detail problem

Post by NilSer »

Hi all!

I have a problem using Zeos 7 version with D2010.

I did a master/detail connection, but when I try to insert and cancel a record on master table, the detail table does not resync detail records.
i tried close and open detail table, but it doesn't work.
Anybody can explain me why?

NilSer

PS: sorry about my english.
seawolf
Zeos Dev Team *
Zeos Dev Team *
Posts: 385
Joined: 04.06.2008, 19:50
Contact:

Post by seawolf »

master/detail query suffer of a well known bug not fixed (and the problem is not clearly identified)
macfsr
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 05.12.2008, 09:51
Location: Germany

Post by macfsr »

Hey NilSer,
I use Master/Detail in my big App (93 Tables) with Zeos 7. You must define Index for both Tables. Use the Field 'LinkedFields' in the Detail Table for the Index Field.

Example:

Table1:(Master)
Field 1: (int) id [use as index or primary key]
Field 2: (varchar[]) text
Field 3: ...

Table2:(Detail)
Field 1: (int)d_id [use as index or primary key]
Field 2: (int)master_id (!!!!)
Field 3: ...


TZTable1:(Master)
TableName = Master
...


TZTable2:(Detail)
IndexFieldName = id asc
LinkedFields=master_id (!!!)
MasterField=id (from Table Master !)
Master_Source= DataSource from Master like TDataSet
...


macfsr





I runs.
Locked