usually, stored procedure returns no value. But Axapta has a class \System Documentation\Classes\UserConnection, which provides access to execute SQL operators. Also Axapta has a class \System Documentation\Classes\Statement, which executes SQL operators (see help on theese classes). In this class exists methods executeQuery() for executing queries, which returns any rows and method executeUpdate() for executing queries, which returns no rows.
Try use theese methods and class \System Documentation\Classes\ResultSet for getting count of your records
|