pears.CollectionsSetChat

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
}