Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
GoogleCodeExporter opened this issue May 27, 2015 · 6 comments
Open

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

GoogleCodeExporter opened this issue May 27, 2015 · 6 comments

Comments

@GoogleCodeExporter
Copy link

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
Copy link
Author

Hi what version are you using?

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

@GoogleCodeExporter
Copy link
Author

TxQuery 2.7

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

@GoogleCodeExporter
Copy link
Author

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
Copy link
Author

HI please check latest release of TxQuery 3.01

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

@GoogleCodeExporter
Copy link
Author

still dose not work.

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

@GoogleCodeExporter
Copy link
Author

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant