====== pears.CollectionsSetChat ======
<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"."CollectionsSetChat"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "pCollectionID" char(20),in "pStaffID" char(20),in "pChatMessage" long varchar ) 
result( "presult" char(50) ) 
begin
  insert into "collectionchat"( "collectionchatid","collectionid","staffid","chatmessage","chatdate" ) values( "uniquekey"("pcollectionid"),"pcollectionid","pstaffid","pchatmessage",current timestamp ) ;
  select '0:~Success'
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."CollectionsSetChat" IS 
{create procedure CollectionsSetChat 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

(in pCollectionID char(20), in pStaffID char(20), pChatMessage Long varchar)
result( presult char(50))
begin
   insert into collectionchat(collectionchatid, collectionid, staffid, chatmessage, chatdate) values(uniquekey(pcollectionid), pcollectionid, pstaffid, pchatmessage, current timestamp);
   select '0:~Success';
end
}
</code>