[Openroad-users] Date data type and .Net

Sergio sergio.sperandio66 at tin.it
Wed Dec 27 20:24:49 EST 2006


Ingres2.6/0305, OpenRoad Application Server 4.1 sp3, C#, ASP.NET

I'm trying to retrieve a value of type DATE from my database, calling a procedure from OpenRoad Application Server. In the byrefPDO parameter I set an attribute "dta_update" of type "STRING". When I retrieve the values of "outputarray.dta_update", I have values as "38777" or "37867" ect. What have I to set to receive a string containing a date value?

Thanks

String data = "";

byrefPDO.DeclareAttribute("outputarray.dta_update", "STRING");

objOR.CallProc(procname, ref byvalPDO_obj, ref byrefPDO_obj);

i_row = byrefPDO.LastRow("outputarray");

for (i = 1; i <= i_row; i++)

{

data = byrefPDO.GetAttribute("outputarray[" + i + "].dta_update").ToString();

}
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://peerlessit.com/pipermail/openroad-users/attachments/20061227/e24c999e/attachment.html 


More information about the Openroad-users mailing list