dbExpress master detail problems.
Posted: Wed 23 Nov 2011 20:32
Hello,
I'm using MSVista, Delphi7, Devart's dbExpress driver 4.70. I drop two TSQLTables (call them A and B), two TDataSetProviders (dspA and dspB), two TClientDataSets (cdsA and cdsB), two TDataSources (dsA and dsB) and two DBGrids (gridA and gridB). Everything is set fine. If I set cdsA.Active to true I see the data in gridA. The same per cdsB.
Now I want to implement the relation. The field a is really foreing key referred by B's field b and b is B's primary key too.
So I set the stuff as follow (I do everything via graphic tools):
When I do i got this error:"ORA-01036: illegal variable name/number". What did I miss? TIA.
Francesco
I'm using MSVista, Delphi7, Devart's dbExpress driver 4.70. I drop two TSQLTables (call them A and B), two TDataSetProviders (dspA and dspB), two TClientDataSets (cdsA and cdsB), two TDataSources (dsA and dsB) and two DBGrids (gridA and gridB). Everything is set fine. If I set cdsA.Active to true I see the data in gridA. The same per cdsB.
Now I want to implement the relation
Code: Select all
A JOIN B ON a = bSo I set the stuff as follow (I do everything via graphic tools):
Code: Select all
cdsB.MasterSource := dsA;
cdsB.MasterFields := a;
cdsB.IndexFieldNames := b;
Code: Select all
cdsB.OpenFrancesco