Skip to content

Multi-relation fields of Master-detail not work #42

@GoogleCodeExporter

Description

@GoogleCodeExporter
these are master-detail codes:
those relations fields only B2_DESC = :B2_DESC dose work.
otheres B2_SPEC = :B2_SPEC and  B3_GRD = :B3_GRD and B3_SZE = :B3_SZE do not 
work.
xQuery := TxQuery.Create(nil);
 with xQuery do
  begin
   DataSource := MasterSrc;
   AddDataSet(C3, 'C3');
   cSQL   := ' select * from C3 ';
   cWhere := ' where  B2_DESC = :B2_DESC and B2_SPEC = :B2_SPEC and         B3_GRD = :B3_GRD and B3_SZE = :B3_SZE ';
   cOrder := ' Order by B2_DESC, B2_SPEC, B3_GRD, B3_SZE ';
   cSQL   := cSQL + cWhere + cOrder ;
   SQL.SetText(PChar(cSQL));
   Open;
end;

delphi 2006 winxp.


Original issue reported on code.google.com by t...@ms9.url.com.tw on 7 Jun 2013 at 3:36

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions