dbExpress master detail problems.

[Francesco]

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

Code: Select all

A JOIN B ON a = b

. 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):

Code: Select all

cdsB.MasterSource := dsA;
cdsB.MasterFields := a;
cdsB.IndexFieldNames := b;

When I do

Code: Select all

cdsB.Open

i got this error:"ORA-01036: illegal variable name/number". What did I miss? TIA.

Francesco

[AlexP]

Hello,

I cannot reproduce the problem. Please try to use the latest version of the driver (5.0.1). If the problem persists, please send an application sample and scripts for creating tables to alexp*devart*com .