最新消息:ww12345678 的部落格重装上线,希望大家继续支持。

Which query range should I select?!

网络文摘 William 1188浏览 0评论
Customer asked me to figure out which "Customer account" should be selected in a query. There were three of them on the Customer invoice journal table:


Apparently, there were a couple of fields that used the default label, and I found them in the following way.

Selected the first "Customer account" range:


... right-clicked in the field value and selected Record Info:


... in the dialog, clicked on the Script button:


... pasted the clipboard to Notepad:


The extended field ID was 65540.

Then, I selected another range:


... and repeated the process. The second field ID was 81625. Finally, I selected the third Customer account range and found that it was based on the field ID 81626.

So, the three field IDs for CustInvoiceJour table were found. But what were the field names?

static void printFieldNames(Args _args)
{
print fieldId2Name(tableNum(CustInvoiceJour), fieldExt2Id(65540));
print fieldId2Name(tableNum(CustInvoiceJour), fieldExt2Id(81625));
print fieldId2Name(tableNum(CustInvoiceJour), fieldExt2Id(81626));
pause;
}

And the output was:

Somebody did not follow the Best Practices for Table Fields:






发表我的评论
取消评论

表情

Hi,您需要填写昵称和邮箱!

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址