Devart Forums

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...

This is a known problem. We will fix it in the next build of the driver.

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 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... :]

We have released the new driver build with the fix.