.NET ParameterSet.getOutputParameter Not Returning Rows From Persistent Procedure

[progresscommunities@progr]

I am running a persistent progress procedure in .NET and passing in a tt datatable as an input-output parameter. Even though there are rows in the table the getOutputParameter() procedure does not return anything. To make it a little clearer in pseudo it looks something like below:



ParameterSet parms = new ParameterSet(1);

parms.setDataTableParameter(1, ttTable, ParameterSet.INPUT_OUTPUT);

Progress.Open4GL.DynamicAPI.Session.runPersistentProcedure(ProcName, parms);



THEN RUN SERVER LOGIC:



DEFINE INPUT-OUTPUT PARAMETER TABLE FOR ttTable.

/* execute code here then message out row count to server log */

ttTable rowcount: 158



BACK TO .NET:



?((System.Data.DataTable)parms.getOutputParameter(1)).Rows.Count
0



CONFUSED!!! any ideas?



Much appreciated...

Continue reading...