Interval data is returned weird

Interval data is returned weird

Postby aspirevishal » Sat 17 May 2008 02:09

Hi,

For a column returning interval data type of postgresql interval.
Datagridview shows weird data e.g
Code: Select all
"3 mons 27 days"


is displayed as
Code: Select all
27.00:00:00


Is that right ?
Last edited by aspirevishal on Mon 19 May 2008 16:26, edited 2 times in total.
aspirevishal
 
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Postby Alexey.mdr » Sat 17 May 2008 08:23

Please send me (alexeyman*crlab*com) or post here a small test project to reproduce the problem.
Include the definition of your own database objects.
We will investigate the problem.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby aspirevishal » Sat 17 May 2008 14:46

test data send. Please acknowledge
aspirevishal
 
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Postby Alexey.mdr » Mon 19 May 2008 08:49

We have received the test data.
We are investigating this problem now.
I will contact you by email in the nearest time.
Could you please specify the versions/editions of:
- PostgreSQLDirect .NET;
- PostgreSQL server;
- OS;
- .NET Framework installed (is it MONO?).
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby aspirevishal » Mon 19 May 2008 16:41

Could you please specify the versions/editions of:

- PostgreSQLDirect .NET 3.50.25
- PostgreSQL server; 8.2.4
- OS; windows xp pro sp3 , tried the same on sp2 results the same
- .NET Framework installed (is it MONO?) , MS .NET 2.0 sp1

and VS 2005
aspirevishal
 
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Postby Alexey.mdr » Tue 20 May 2008 09:37

Hello,

I have sent you an email with solution.
Let me know if the problem is solved.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby aspirevishal » Tue 20 May 2008 15:52

No , the problem is stilll their . The interval comes with a trialling time . check the e-mail I have send you.
aspirevishal
 
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Postby aspirevishal » Thu 22 May 2008 05:06

should I expect something new ?

I mean is something cooking ,as far as this problem is concerned.
aspirevishal
 
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Postby Alexey.mdr » Thu 22 May 2008 13:09

Please check you email.
The solution is to set a proper format for the column in the DataGridView.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby aspirevishal » Thu 22 May 2008 14:53

I have already tried that , moreover to best of my knowledge if no formatting is used in DefaultCellStyle property it should return the data as it is .


moreover you have the test case and you could have tried that yourself :shock:

later we could have discussed, how to make it work.
aspirevishal
 
Posts: 30
Joined: Fri 31 Aug 2007 03:30
Location: India

Postby Alexey.mdr » Fri 23 May 2008 09:36

Unfortunately, we cannot provide a general advice on using formatting in DataGridView because this topic is beyond the scope of our support program.
TimeSpan struct doesn't have native implemented formatting
Code: Select all
public struct TimeSpan : IComparable, IComparable, IEquatable
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for PostgreSQL