使用搜索功能查看 Kepware 的信息库,其中包含 500 多篇知识库文章。缩小搜索结果范围,或在下面的搜索字段中输入您的查询。

或者,如果您无法找到解决方案,我们还有另一个资源:我们的 PTC eSupport Portal。 如果系统提示您登录 eSupport Portal,您可以使用“我的 Kepware”凭据。需要一个“我的 Kepware”帐户吗?在此处创建

搜索解决方案结果:
View All Solutions

Kepware Knowledge Base: Solution


Setting a Table to Always Display the Last Record


Last Update: 2018/11/7

Problem:
An application is logging data to a table. Users need to read the last value after it is logged.

Solution:
Although there is no way to configure the table with an ODBC Client driver setting, users can try the following:

1. If every record has a Unique ID that can be sorted, do a descending order index sort on that number. This will always place the last record at the beginning of the list when using a fixed or dynamic table.
2. For large data tables, do a query of the last 5 or 10 records. Then, order by the Record ID. A descending order index sort can also be used that points to a query in the database or query table when using a fixed or dynamic table.
3. Every time that the record count changes, write a 1 to the _MoveLast Tag when using a dynamic table. This will always place the pointer at the last record. To automate the process, use LinkMaster or the OPC DX Plug-In.

Related Products
ODBC Client