Все же нашел кое-что:
Цитата:
But it can be problem of Navision on MS SQL, when sometime Navision does not "see" all entries (it is problem with transfer Item LE, adjustments etc...) - in some situations you know, that there are 2 records in the filter but after first NEXT C/AL say that there is no more records...
Fix is execute this command:
UPDATE [$ndo$dbproperty] SET diagnostics = 131072
...
Цитата:
It (flag 131072) disables an optimization to avoid using SQL cursors in some situations when doing FIND('-'), to instead use a default result set - or firehose as its sometimes called. This is more efficient that SQL cursors.
There was a problem with this but it should be addressed by obtaining the latest c/side hotifx and not by changing this value, although as a short-term solution is is useful.
http://dynamicsuser.net/forums/p/2283/9967.aspx