Bug at v 6.90.0.54 Or other behaviour rather v 5.80.0.43

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Sunny
Posts: 1
Joined: Tue 05 Jan 2010 08:27

Bug at v 6.90.0.54 Or other behaviour rather v 5.80.0.43

Post by Sunny » Tue 05 Jan 2010 08:50

I have the licence to version 5.80.0.43. I think to prolong the licence to last version. downloaded trial ODAC 6.90 for Delphi 7 for the test. And at once there was a problem:

Code: Select all

var
Master, Detail: TOraQuery;
MasterSource: TDataSource;
begin
  Master := TOraQuery.Create(Self);
  Master.SQL.Text := 'select 3 id  from dual where 1=0';   //dont work
 // Master.SQL.Text := 'select 3 id  from dual';           // work
  Detail := TOraQuery.Create(Self);
  Detail.SQL.Text :='Select * from '+
                    '(select 1 id   from dual union all '+
                    'select 2 id  from dual union all '+
                    'select 3 id  from dual union all '+
                    'select 4 id  from dual union all '+
                    'select 5 id  from dual )';
  Detail.MasterFields := 'id';
  Detail.DetailFields := 'id';
  MasterSource := TDataSource.Create(Self);
  MasterSource.DataSet := Master;
  Detail.MasterSource := MasterSource;
  Master.Session:=OraSession;
  Detail.Session:=OraSession;
  Master.Open;
  Detail.Open;

  Master.Edit;
  Master.FieldByName('id').AsInteger:=4;
  Showmessage('MasterFieldValue: '+Master.FieldByName('id').AsString +  ' DetailFieldValue: ' + Detail.FieldByName('id').AsString);
It is a bug?
Detail is not Refresh, when Master receives new value of MasterFields.
I do not have such problems at v 5.80.0.43.

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Wed 13 Jan 2010 13:40

Set the RefreshParamsOnInsert global variable from the DBAccess unit to True.

Post Reply