calling SQL sp from Axapta

[sukhanchik]

Цитата:

Say, my return procedure returns an integer:

Your procedure cannot return value (Transact-SQL ?).
Function can return value. If you use a function, I recommend to write:

PHP код:

        cmd.commandType(1);  //adCmdText, see ObjectBrowser in VBA
    parameter = "Parameter value";

    cmd.CommandText(strfmt("SELECT spTestReturnRecordset '%1'", parameter)); 


as wrote Ace of Database, but do replace EXEC on SELECT