pears.DashboardObjectSet

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

Original SQL

CREATE PROCEDURE "pears"."DashboardObjectSet"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pID" CHAR(20) DEFAULT NULL,IN "pType" CHAR(50) DEFAULT NULL,IN "pTitle" CHAR(250) DEFAULT NULL,IN "pDescriptor" long VARCHAR DEFAULT NULL ) 
RESULT( "id" CHAR(20) ) 
BEGIN
  IF "pID" IS NULL THEN
    SET "pID" = "uniquekey"('')
  END IF;
  INSERT INTO "DashboardObject"( "DashboardObjectID","StaffID","Type","Title","Descriptor" ) ON existing UPDATE defaults off VALUES( "pID","userstaffid","pType","pTitle","pDescriptor" ) ;
  SELECT "pID"
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."DashboardObjectSet" IS 
{CREATE PROCEDURE DashboardObjectSet 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
( IN pID CHAR(20) DEFAULT NULL,IN pType CHAR(50) DEFAULT NULL,IN pTitle CHAR(250) DEFAULT NULL,IN pDescriptor long VARCHAR DEFAULT NULL ) 
RESULT( id CHAR(20) ) 
BEGIN
  IF pID IS NULL THEN
    SET pID = uniquekey('')
  END IF;
  INSERT INTO DashboardObject( DashboardObjectID,StaffID,TYPE,Title,Descriptor ) ON existing UPDATE defaults off VALUES( pID,userstaffid,pType,pTitle,pDescriptor ) ;
  SELECT pID
END
}