franzM - So 06.07.08 21:11
Titel: SQL Window und Dezimal Punkt

---

Mein Deutsch ist nicht so gut. Also ist meine Frage hirunter in Englisch gestellt. Sie koennen in Deutsch antworten.

I'm using Delphi 2007 for Win32 on Windows Vista SP1 Home Edition with English (USA) country settings.
Under dbExpress BlackfishSQL I create a new database ABTest. Connection test succeeds. Right clicking I open an SQL Window. I create a table using
"CREATE TABLE ABTEST (Floatfield float);"
Filling in a record with:
"INSERT INTO ABTEST (3.45);"
followed by
"SELECT * from ABTEST";
The SQL Window shows me: 345, niet 3.45.
Who knows what I am doing worng?

Gruessen,

Franz

mkinzler - So 06.07.08 21:15

---

Which decimal separator is configured?

franzM - So 03.08.08 12:12

---

Hi,

where to check for the decimal separator?

Franz

mkinzler - So 03.08.08 12:23

---

It's configured by the constant DecimalSeparator