- Wed Nov 06, 2013 3:07 pm
#765349
I have a dependent field (text field with Validate ANY) that has a SQL Connection with SQL to query an invoicing table on a MS SQLServer. The SQL query obtains the selling price which is a Decimal(11,4) field. The dependent field/SQL works and retrieves the data, however it only ever shows a whole number - the decimal precision is not obtained (e.g. SQL Table field is 51.5900, but Processmaker retrieves 51). Is this a bug (I am running version 2.0.45) or is there something I am missing?