dbExpress master detail problems.

dbExpress master detail problems.

Postby Francesco » 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
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
Francesco
 
Posts: 9
Joined: Thu 20 Jan 2011 16:33

Postby AlexP » Thu 24 Nov 2011 08:11

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 .
AlexP
Devart Team
 
Posts: 5530
Joined: Tue 10 Aug 2010 11:35


Return to dbExpress driver for Oracle