pears.FormatCompanyAddress

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"."FormatCompanyAddress" IS 
{CREATE FUNCTION FormatCompanyAddress 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN ReqCompanyID CHAR(20),IN Capitalise SMALLINT,IN STYLE CHAR(1))
RETURNS long VARCHAR
BEGIN
  DECLARE FormattedAddress CHAR(300);
  SET FormattedAddress=FormatCompanyAddress1_0(ReqCompanyID,Capitalise,STYLE);
  RETURN FormattedAddress
END
}
  • database/procedures/pears_formatcompanyaddress.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1