Insert problem

[rido111]

Hi,

Anyone knows how to use double numbers especially including commas (like 75,5) in an insert query?
(DB is MSAccess, field type is double)

 

[archer_coal]

RE:

i dont know about the rest of the Number formats but i think double and long integer are intended for a single number and needs to be formatted after you pull it from the db to add ,

ive tried several methods and none work. At best i can insert the number values but the comma is discarded somehow.

you might change the property to text and format it as double after you retrieve it.

 

[APaule]

In Access and the SQL Server (and I think all the other database-systems as well) you have to use a decimal point as separator in a SQL statement

 

[rido111]

Problem Solved

Thank you for replies...

I have solved the problem using built-in convert function CDbl() as in example:

INSERT INTO temp (name,value) VALUES (rido,CDbl(35,23))