Problem with numeric() type.

Problem with numeric() type.

Postby Dennnis » Thu 14 May 2009 11:41

Hi...

I have a program, here in Brazil, and my company decided to use PostgreSQL. Our program use more than 2000 tables in the database, and to be more easy we use Domaind to keep the database.

So I find your component and I was testing, when I found 1 problem.

When I have a table without using "DOMAINS", I can commit numeric values ( ex: U$ 15.35 ).
But, I have a table with "DOMAINS" i got the error like "coulnd't insert numeric value: 15,35".

Important: in Brazil, the numeric value formating is: 9.999.999,00 (with "," separeting decimals).

Well, I use PostgreSQL 8.3.7 with Delphi 7.

To show the problem to you, i make one example to download.
Into the example has the SQL, pas and dpf files...

link: http://cid-a5abaf4bf1d62480.skydrive.li ... -DENIS.zip

But, remenber, your windows need to use the monetary patterns from Brazil. US pattern works!

Maybe I'm doing something wrong. It's a possible too...

Dennnis.

PS: Sorry about my english. I'm learning yet. I hope you understand.

-----------------
Edit (2009-05-19):
I test this problem with another driver and I don't get this problem.
Your driver is more fastest than the other one, but have this problem...
Dennnis
 
Posts: 2
Joined: Thu 14 May 2009 01:18

Postby Plash » Wed 20 May 2009 09:03

This is a known problem. We will fix it in the next build of the driver.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Re: Problem with numeric() type.

Postby Michel Moreira » Wed 27 May 2009 19:17

Dennnis wrote:-----------------
Edit (2009-05-19):
I test this problem with another driver and I don't get this problem.
Your driver is more fastest than the other one, but have this problem...


Brazil? Are u using the Vitavoom's driver? This company doesnt update the driver, and says that the bug doesnt exist, doesnt answer emails nor have any other way to contact them!!!

I'm glad to hear about the beta from devart/corelab, Now I'll be in better hands!
Michel Moreira
 
Posts: 4
Joined: Tue 18 Dec 2007 14:49

Re: Problem with numeric() type.

Postby Dennnis » Thu 28 May 2009 23:34

Michel Moreira wrote:
Dennnis wrote:-----------------
Edit (2009-05-19):
I test this problem with another driver and I don't get this problem.
Your driver is more fastest than the other one, but have this problem...


Brazil? Are u using the Vitavoom's driver? This company doesnt update the driver, and says that the bug doesnt exist, doesnt answer emails nor have any other way to contact them!!!

I'm glad to hear about the beta from devart/corelab, Now I'll be in better hands!


No, I'm not using. I just testing the alternatives...
With the vitavoom's driver numeirc domains works, but, others parts don't...
Ex: I'll use more then one DB (firebird, oracle and postgresql if averything work correctly...).
Because of the DBs, all sqls of my application were writed in capital leters. But the vitavoom's driver aways use the caracter ( " ) in tables, fields, etc... (to be short) and with this char, the postgre doesnt found the tables... So, because of that, I wont use this driver...

So, anyway, I'll wainting for the next build to finish my tests and them (maybe) start to work with postgresql ...

[ off topic ] E sim, Brasil. Aliás seu nome me diz que você também é brasileiro... :]
Dennnis
 
Posts: 2
Joined: Thu 14 May 2009 01:18

Postby Plash » Fri 12 Jun 2009 09:04

We have released the new driver build with the fix.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for PostgreSQL