Oracle -> ADO type conversion.

[carpen]

Hi all friends!

I have a little problem with an application that reads
data from an oracle DB.

Here in sweden we uses "," as decimal separator for ie. currency.

My application collects a number of rows with items and items prices and prints them on an invoice.

The problem is that ADO strips "," from items prices and thus adding the item value by a hundred times.. ie. "16,22" becomes "1622" in the recordset price field.

The field in question has adNumeric as data type.

What must I do to get the "," to stay in place??

regards,
Jesper

[monte96]

There may be an international setting that needs to be set on the Oracle server (Or the PC running the app). Check Regional settings on your client PC and if your running Oracle server on a NT box, check it there as well.. If you running it on a Unix box you will have to check an Oracle manual.

Also, when setting up your ODBC DSN, check to see if it is configured to use Regional Settings.

[carpen]

Hi!

Other programs like Winsql using the same DSN gets the right number format.. It's only my ADO VB project that gets it all wrong..

Therefore I think that there must be some sort of switch or delimiter setting somewhere that needs to be tuned.

Regards,
Jesper

[kovan]

monte is right

there is an international setting that needs to be changed to . so that it will stay..

i remember changing it from "." to "," and vise versa but i forgot how..

[carpen]

I'm not saying he is wrong. Just wondering why other applications using the same drivers and same system DSN can retreive the information correctly and VB (ADO) can't.

I learnt today that by using ' around the fieldname in the sql-query ADO is forced to accept "," as decimal notation. Haven't tried it yet though.

/jesper

[kovan]

easier solution would be to have all those european countries use the DOT instead
hehhe