The feature of using temporary tables was designed a long time before the SQL option was introduced. On SQL Server, it is known that sorting of alpha-numeric data can be different than on the Native database. For example, on Native, you would get this sort order in a code field:
The same table running on a SQL Server (provided the field is of type Code or Text) would be:
So a C/AL developer should be aware that when using a temporary table on the SQL option, the sorting may be different than expected.
This is by design from the time before the SQL option was introduced. And in the interest of backwards compatibility, it will not be changed.
ID Bài viết: 2425765 - Xem lại Lần cuối: 27-01-2017 - Bản sửa đổi: 2