Within an VB.net application I'm trying to store decimal values to a
Pervasive SQL table. The decimal values comes from a xml file and is
looking something like:
<Grade1>6.65</Grade1>
<Grade2>6.66</Grade2>
<Grade3>6.0</Grade3>

When I look for the results in the database I find 665, 666 and 60 for
the corresponding columns. All types are setup as decimals. What I'm I
doing wrong?

Regards,
Hans

"Hans van de Laar" <hansvandelaar.replace.at.micros.nl> wrote


It appears that Pervasive doesn't understand .NET System.Decimal. I'd ask
Pervasive tech support:

http://ww2.pervasive.com/Pages/Products.aspx (click the Support tab).

It could be also a conversino problme issue. For example if you convert
those value with . as the thousand separator, it's likely you'll get the
same result (i.e. the point is dropped and it left you with 665, 666 and
60).

I would check where you convert text values to decimals and would check the
cultutre that you are currently using.

--
Patrice

"PvdG42" <pvdg (AT) toadstool (DOT) edu> a écrit dans le message de news:
uO6E8258HHA.536 (AT) TK2MSFTNGP06 (DOT) phx.gbl...

Patrice,

Thanks, it seems indeed a culture info problem. I programmatically
changed the culture to "n-US" and I noticed the values are now stored
correctly into the database.

Thanks,
Hans

Patrice wrote: