pears.FormatPersonAddress

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