I have a table containing a column of floating point numbers, some of which are negative. I have a query which contains a parameter (“Table”.“myValue” = :myValue). When I run the query I get the dialog box asking me to enter the parameter but if I try to enter a negative number such as -0.25 it automatically puts a space between the minus sign and the rest of the number and returns no rows. Entering positive numbers without the minus sign returns rows as expected. Does anyone know how to get round this problem?
Replacing :myValue with :myValue*1 solved the problem.
1 Like