Zeoslib Portal

I couldn't solve the problem so I took a different approach to obtain what I need:

I created a view that contains all the required fields plus the to_char function, this way when I query "SELECT * FROM view_table" the number is formatted the way I expect it to be.

bye,
Daniele

Hi,
I tried what you suggested but I can see no errors in the log:

2006-11-28 15.24.59 cat: Execute, proto: postgresql-8, msg: SELECT trim(to_char(impo, '9G999G999G990D99')) AS impox, * FROM q_rate

is there something I'm not doing right?

bye,
Daniele

I forgot: I also updated Zeos to the last release 6.6.0 beta.

Daniele

Hi everyone, I'm having problems with the function to_char in a query on postgresql 8.1.5 and Delphi 7 Pro. There's this function in my query: "trim(to_char(impo, '9G999G999G990D99'))" this should return a number with locale (Italian) settings and works fine if I try this at designtime, bu...