pears.TempRatePrecision

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

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."TempRatePrecision" IS 
{CREATE FUNCTION 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) END IF INTO rv;
  RETURN rv;
END
}
  • database/procedures/pears_temprateprecision.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1