The function JRDEC can be used in any SQL statement to check decimal numbers. To do so enter the function name JRDEC followed by the variable e.g. JRDEC(invoiceamount) for a process table field or JRDEC[invoiceamount] for a form element. The function ensures that only decimal numbers or integers are used in the SQL command.
Example:
UPDATE TABLE SET AMOUNT= JRDEC[invoiceamount] WHERE …
