leeonsoft / txquery

Automatically exported from code.google.com/p/txquery
Other
0 stars 0 forks source link

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

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
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

GoogleCodeExporter commented 9 years ago
Hi what version are you using?

Original comment by fdue...@gmail.com on 12 Jun 2013 at 6:51

GoogleCodeExporter commented 9 years ago
TxQuery 2.7

Original comment by t...@ms9.url.com.tw on 13 Jun 2013 at 2:23

GoogleCodeExporter commented 9 years ago
Hi please check the latest version posted in this issue:
http://code.google.com/p/txquery/issues/detail?id=40

Original comment by fdue...@gmail.com on 23 Jul 2013 at 9:23

GoogleCodeExporter commented 9 years ago
HI please check latest release of TxQuery 3.01

Original comment by fdue...@gmail.com on 1 Aug 2013 at 6:02

GoogleCodeExporter commented 9 years ago
still dose not work.

Original comment by t...@ms9.url.com.tw on 3 Aug 2013 at 3:52

GoogleCodeExporter commented 9 years ago
very sorry, I made a mistake.
The TxQuery 3.01 Dose work for Multi-relation fields of Master-detail. 

Thanks a lot.

Original comment by t...@ms9.url.com.tw on 5 Aug 2013 at 1:31