[Openroad-users] Date data type and .Net

[neil.warnock at luminary.co.uk]

Hi Sergio

'Date' is a supported datatype. But beware the dst and date format nightmares! Your idea of materialising and passing  dates as strings can simplify matters and is a good one in most  circumstances but think it through. What date do you really want in the calling client? The db date? The appserver date? The client date? And what if there are multiple appservers in the chain? A bit of a minefield! 
Hth

Neil


Typed painfully slowly on Blackberry wireless device  

-----Original Message-----
From: "Sergio" <sergio.sperandio66 at tin.it>
Date: Wed, 27 Dec 2006 10:24:49 
To:"OpenRoad user list" <openroad-users at peerlessit.com>
Subject: [Openroad-users] Date data type and .Net

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();
 
}
_______________________________________________
Openroad-users mailing list  Openroad-users at peerlessit.com

To unsubscribe please click on this link
mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe

To subscribe please click on this link
mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe