ACUMATICA BQL查询
ACUMATICA BQL查询
提问于 2020-03-21 08:54:00
我需要使用BQL从数据库返回记录。我尝试过编写类似于以下TaxZone zone = PXSelectJoin<TaxZone, InnerJoin<LocationExtAddress, On<TaxZone.taxZoneID, Equal<LocationExtAddress.cTaxZoneID>>, InnerJoin<Customer, On<Customer.bAccountID, Equal<LocationExtAddress.bAccountID>>, Where<Customer.bAccountID, Equal<Current<Customer.BAccountID>>>;的BQL查询，并得到了错误
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term '<'
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1525: Invalid expression term ','
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(387): error CS1002: ; expected我也试过使用像这个Customer cust = PXSelect<Customer, Where<Customer.bAccountID, Equal<Current<Customer.bAccountID>>>;这样的DAC，我仍然会收到错误
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1525: Invalid expression term '<'
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1525: Invalid expression term ','
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1525: Invalid expression term '>'
\App_RuntimeCode\SOOrderEntry.cs(383): error CS1002: ; expected
Compiler time, in seconds: 21.1134712在这个问题上的任何帮助都将是非常感谢的，因为我已经阅读了文档，这是支持编写的格式。
Stack Overflow用户
回答已采纳
发布于 2020-03-23 06:02:17
TaxZone zone = PXSelectJoin<TaxZone, InnerJoin<LocationExtAddress, On<TaxZone.taxZoneID, Equal<LocationExtAddress.cTaxZoneID>>, InnerJoin<Customer, On<Customer.bAccountID, Equal<LocationExtAddress.bAccountID>>>>, Where<Customer.bAccountID, Equal<Current<Customer.bAccountID>>>>.Select(graph); 页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/60786006
复制相关文章
相似问题
腾讯云开发者
