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

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

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

Kepware Knowledge Base: Solution


How Does the ODBC Client Driver Sort Data Returned from a Table?


Last Update: 2018/11/7

The way that returned data is sorted depends on the device format selected in the server and the specified data source format.

  1. For Fixed Table or Dynamic Table formats going directly to a data table, the returned record set is sorted by the key field as indicated by the table. Typically, the key filed is the record number.
  2. If the data source is a query or view within the database, then the returned record set is sorted according to the sort parameters within that query or view.
  3. If the format selected in the server is Query Table, then the sorting is inherited from the queried data source unless an OrderBy clause is used in the select statement.

Note: An example query statement is "Select * From Production.Products OrderBy Product_Name ASC".

Related Products
ODBC Client