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...
Problem with numeric() type.
-
Michel Moreira
- Posts: 4
- Joined: Tue 18 Dec 2007 14:49
Re: Problem with numeric() type.
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!!!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...
I'm glad to hear about the beta from devart/corelab, Now I'll be in better hands!
Re: Problem with numeric() type.
No, I'm not using. I just testing the alternatives...Michel Moreira wrote: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!!!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...
I'm glad to hear about the beta from devart/corelab, Now I'll be in better hands!
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... :]