I'm new with SDAC so be patient....
I have a number of SQL Stored Procedure with arguments that work fine with TMSStoredProc. However I'm a little confused as to where the return value of a SQL Function is stored. For example I can issue a T-SQL command like:
SELECT @rtn = usp_GetRowCount('tablename')
With TMSStoredProc I do this:
SP := TMSStoredProc.Create(nil)
SP.Connection := Conn (assume it was initialized)
SP.StoredProcName = 'usp_GetRowCount;1';
SP.Params.ParamValues['Table'] := 'tablename';
SP.FetchAllRows := TRUE;
SP.Execute;
Where do I find the return value.
Thanks