Question for Sql (HOT)

[vagelisr]

Hi to all

I have a huge problem
I use this sql ( sSql = "SELECT capacity_pieces_sec FROM capacity WHERE capacity_material_code= '" & bkpdwnH_material_code & "' and capacity_machn_code= '" & bkpdwnH_machn_code & "' and capacity_number_employee =" & bkpdwnH_number_employee)
but my last field is decimal and i receive a run time error because of the , (comma)
What is the correct syntax to understand my SQL the last field???
my last field has value 2,5
Thanks and regards!!!!!!!!

 

[pr2-eugin]

Try a . instead of a ,

Decimals are represented as 2.5

 

[vagelisr]

In my case it does not represented as 2.5 but as 2,5 (for this reason i face the error)

Tha value 2,5 is from my last field.....

 

[pr2-eugin]

Then use

CDbl(Replace("2,5", ",", "."))

 

[vagelisr]

It work like a charm!!!!!

 

[pr2-eugin]

Okay that is just a work around.. The main question here is why do you have a comma instead of the regular .?

 

[JANR]

Okay that is just a work around.. The main question here is why do you have a comma instead of the regular .?

The answer would be regional settings, to get around the issue when creating SQL you can use the str() function which converts the comma to dot which SQL understand.

see this link: http://www.access-programmers.co.uk/forums/showthread.php?t=220498&highlight=str+function

JR

 

[pr2-eugin]

see this link: http://www.access-programmers.co.uk/forums/showthread.php?t=220498&highlight=str+function

JR

Thank you JR for the link.. was interesting to know that..