[fpc-devel] Master/Detail problem with Tdbf

Christian Ulrich z0m3ie at gmx.net
Thu Oct 5 12:54:49 CEST 2006


I have an strange Issue here with tdbf and master/detail.
I have 2 sorts of Master/Detail relationships in this project.
at first with FIELD based indexes:
At example i haven an customers table and and customercontact table.
both have an Field ACCOUNTNO over what the master / detail relationship is
added. this field is indexed in customercontact.

Master/Detail works only sometimes. Sometimes it works great and sometimes i
see all records in the customercontact table.
I cant see any differences. when i delete the tables after it hasnt been
worked and recreate them it works and sometimes the other direction.

The same bug occours with indexes with more fields. But there it occours
oftener. I have some tables with indexes in this way :

AddIndex('ARTICLENO','ARTICLENO+VERSION+LANGUAGE',[ixPrimary,ixUnique]);
MasterFields := 'ARTICLENO+VERSION+LANGUAGE';

there this problem occours very often.
I use tdbf from fpc svn.

regards
Christian





More information about the fpc-devel mailing list