database:functions:pears_temprateprecision



pears.TempRatePrecision

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."TempRatePrecision"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "TempUnits" NUMERIC ) 
RETURNS NUMERIC
BEGIN
  DECLARE "rv" NUMERIC;
  SELECT IF "isnull"("TmpRatePrecision",0) = 2 THEN "iqmoneyround"("TempUnits") ELSE "round"("TempUnits","TmpRatePrecision") endif INTO "rv";
  RETURN "rv"
END
  • database/functions/pears_temprateprecision.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1