Open API + .net

Posted by Admin on 01-Jul-2008 04:49

Hi,

I am trying to get a temp-table or temp-table handle from a progress procedure run from a .net client via appserver using the open API for .net.

Can somebody point to the right documentation (or tell me what going wrong)?

Is there a sample code that I can look at?

The open client guide (sadly) does not have any examples for temp-table, using open API.

TIA.

Parul.

// .net code

Connection myConn = new Connection("AppServer://localhost:5162/asbroker1", "", "", "");

myConn.SessionModel = 1;

OpenAppObject openAO = new OpenAppObject(myConn, "mySvc");

System.Data.DataTable outDT = null;

DataTable table = new DataTable();

TempTableMetaData tt_meta = new TempTableMetaData(table.TableName, "WindowsFormApplication3", 2, true, 1, "1, Mine-id:Num-i", System.String.Empty, System.String.Empty);

tt_meta.SetFieldMetaData(1, "tta", 0, Progress.Open4GL.Parameter.PRO_CHARACTER, 0, 0);

tt_meta.SetFieldMetaData(2, "ttb", 0, Progress.Open4GL.Parameter.PRO_CHARACTER, 1, 0);

ParamArray params_1 = new ParamArray(1);

params_1.AddTable(0, table, ParamArrayMode.OUTPUT, tt_meta);

openAO.RunProc(@"C:/eclipse/europa/workspace/psc/test/rettemp.p", params_1);

/*-----------------rettemp.p ---------------------*/

DEF TEMP-TABLE tt1

FIELD tta AS CHAR

FIELD ttb AS CHAR

.

DEF OUTPUT PARAMETER TABLE FOR tt1.

All Replies

Posted by maura on 07-Jul-2008 15:59

Posted by Admin on 10-Jul-2008 07:56

This thread is closed