На всякий случай, по поводу первого постинга и ошибки компиляции: в АХАРТА нельзя использовать order by и group by в одном запросе. Раздел справки "Differences between X++ and SQL in handling group by": "... As opposed to SQL, X++ does not allow group by and order by in the same select statement. This means that explicit sorting is not possible. ..."
__________________
Андрей.
|