是否有办法禁用 Dynamics AX 中的网格缓存？
最好是能够全局禁用这个无用的、烦人的功能的东西。
更新 1
默认情况下，Dynamics AX 仅显示网格的前 20 行。这是一个可怕的功能。我无法一眼看出网格中有多少数据。我无法快速滚动到我想要的数据，因为一旦超过 19 条，它就只有“转到最后一条记录”，然后仅更改为最后 20 条记录。
或者：我怎样才能让网格只显示所有数据？
此功能按设计工作，这只是一个垃圾功能。
更新 2
我添加了一张图片来说明我正在谈论的内容。此查找仅显示前 10 行。一旦您将滚动条移至底部，您所看到的就是转到最后一条记录。我不知道是有20个选择还是2000个！这种行为在普通网格中也是相同的，尽管我认为它们显示 20 行。 
更新 3
我们公司的 AX 专家告诉我，他确实设法禁用了此缓存，尽管它需要SQL Server 端的更改并引入了一些稳定性问题。由于没有人能够提供答案，所以我将保留这个问题。
Preferably something that will disable this useless, annoying feature globally.
Update 1
By default, Dynamics AX shows only the first 20 rows of a grid. This is an awful feature. I cannot see how much data is in the grid at a glance. I cannot quickly scroll to the data I want because once you get past 19 it only has "Go To Last Record" and then changes to only the last 20 records.
Or: How can I make grids just show all their data?
This feature is working as designed, it's just a crap feature.
Update 2
I've added an image to illustrate what I'm talking about. This lookup is only showing the first 10 rows. As soon as you move the scroll bar to the bottom, all you see is Go to the last record. I have no way of knowing if there are 20 choices or 2000! This behaviour is the same in normal grids as well, although I think they show 20 rows instead.
Update 3
I was informed by our companies AX guru that he did manage to disable this caching, although it required changes on the SQL Server end and introduced several stability issues. Since no-one was able to provide an answer, I'll leave this question open.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
AX（与大多数系统一样）不会将表中的所有记录提取到表单中，因为它使用 SQL 游标。它通常会将第一轮获取的记录数限制在 20 到 50 之间。这通常是最佳行为，因为事先不知道记录数。
不，它不能被禁用。
资源： 重要提示...
AX (as most systems around) does not fetch all records from the table to the form because it uses a SQL cursor. It will typically limit the number of records fetched in the first round to between 20 and 50. This is usually optimal behaviour as the number of records is not known beforehand.
And no, it cannot be disabled.
Ressources: Top tips ...
如前所述，这是一个您不想关闭的“功能”（即使它确实很烦人），因为存在损坏您自己的计算机/SQL 服务器的风险，或者在最坏的情况下会损坏数据。
我可以建议，如果您确实需要知道（是的，有时预先知道很重要）表中有多少行，您可以编写一个方法来计算字段并根据需要将其显示在表单或网格上。
As stated, this is a 'feature' (even if it is really annoying) that you would not want to turn off, due to the risk of crippling your own machine / SQL server, or in the worst case corrupting the data.
Can I suggest that if you really need to know (and yes sometimes it is vital to know up front) how many rows are in the table you write a method to count the fields and display it on the form or on the grid as necessary.