pears.DashboardObjectSet [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.DashboardObjectSet ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code 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
}
</code>