Master-Detail & CachedUpdates: foreign key not auto filled

[Opet]

Please look at this simple case. I have 2 MySQL tables:

Master
======
IdMaster int autoinc
FMaster varchar(100)


Detail
======
IdDetail int autoinc
IdMaster int
FDetail varchar(100)


I have 2 TUniQuery components, qMaster and qDetail. They were set up this way:

Code: Select all

qMaster.CachedUpdates:=true;
qMaster.SQL.Text:='select * from Master';

qDetail.CachedUpdates:=true;
qDetail.SQL.Text:='select * from Detail where IdMaster = :IdMaster';
qDetail.DataSource:=dsMaster; //dsMaster is the DataSource of qMaster
qDetail.Options.LocalMasterDetail:=true; //tried with and without this

Now here is the problematic code:

Code: Select all

qMaster.Open;

qMaster.Append;
qMaster['FMaster']:='this is master rec A';
qMaster.Post;

qDetail.Open;

qDetail.Append;
qDetail['FDetail']:='this is detail rec #1 of master rec A';
qDetail.Post;
qDetail.Append;
qDetail['FDetail']:='this is detail rec #2 of master rec A';
qDetail.Post;

qMaster.ApplyUpdates;
qDetail.ApplyUpdates;

The IdMaster field in the Detail table don't filled automatically. How to make it get filled automatically?

Thank you.

[AndreyZ]

Hello,

When you are using CachedUpdates, your master-table doesn't get data from the server. And your master-field is autoincrement, which means that you want server to give value for this field. To solve the problem you should change your code to the following:

Code: Select all

  qMaster.Open;
  qMaster.Append;
  qMaster['FMaster']:='this is master rec A';
  qMaster.Post;
  qMaster.ApplyUpdates; // here you are retrieving the IDMaster field value from the server

  qDetail.Open;
  qDetail.Append;
  qDetail['FDetail']:='this is detail rec #1 of master rec A';
  qDetail.Post;
  qDetail.Append;
  qDetail['FDetail']:='this is detail rec #2 of master rec A';
  qDetail.Post;
  qDetail.ApplyUpdates;

[Suhaimin]

i tried 2 table in postgresql

Master
======
IdMaster int
FMaster varchar(100)


Detail
======
IdDetail int
IdMaster int
FDetail varchar(100)


I have 2 TUniQuery components, qMaster and qDetail.

Code: Select all
qMaster.CachedUpdates:=true;
qMaster.SQL.Text:='select * from Master';
qDetail.Options.LocalMasterDetail:=true;

qDetail.CachedUpdates:=true;
qDetail.SQL.Text:='select * from Detail where IdMaster = :IdMaster';
qDetail.DataSource:=dsMaster; //dsMaster is the DataSource of qMaster
qDetail.Options.LocalMasterDetail:=true; //tried with and without this



onnewinsert qmaster :
qmasterIdmaster.value := 100 // manually;


onnewinsert qdetail :
qdetailidmaster.value := qmasteridmaster.value;


Tdbgrid connect to qdetail. i entry data via dbgrid but after post (move to next row of tdbgrid) the data that i entry missing from dbgrid. why this happened ?
thanks a lot.

[DemetrionQ]

Hello.

I answered to you at the theme
  http://forums.devart.com/viewtopic.php?f=28&t=27112

[Suhaimin]

thanks

[DemetrionQ]

If any questions come up, please contact us.