[Openroad-users] Date data type and .Net

[Sergio]

I have to retrive every date data type (GMT offset) attributes of my ingres
database.

----- Original Message ----- 
From: <neil.warnock at luminary.co.uk>
To: <neil.warnock at luminary.co.uk>; "International OpenROAD Users"
<openroad-users at peerlessit.com>
Sent: Wednesday, December 27, 2006 12:52 PM
Subject: Re: [Openroad-users] Date data type and .Net


Sorry when I say 'date' below  I usually mean 'GMT offset'. It is so fraught
with problems I can't even explain it properly! Must be the xmas excess
taking its toll



Typed painfully slowly on Blackberry wireless device

-----Original Message-----
From: neil.warnock at luminary.co.uk
Date: Wed, 27 Dec 2006 11:08:12
To:"International OpenROAD Users" <openroad-users at peerlessit.com>
Subject: Re: [Openroad-users] Date data type and .Net

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

_______________________________________________
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

_______________________________________________
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