pears.CollectionsSetNote

CREATE PROCEDURE "pears"."CollectionsSetNote"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pCollectionID" CHAR(20),IN "pStaffID" CHAR(20),IN "pChatNote" long VARCHAR ) 
RESULT( "presult" CHAR(250) ) 
BEGIN
  CALL "AuditLog"('COLLECTION',"pcollectionid",
  "string"('Collection Notes Changed - ',(SELECT "name" FROM "collection" WHERE "collectionid" = "pcollectionid")),(SELECT "notes" FROM "collection" WHERE "collectionid" = "pcollectionid"),"pChatNote");
  UPDATE "collection" SET "notes" = "pChatNote" WHERE "collectionid" = "pcollectionid"
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."CollectionsSetNote" IS 
{CREATE PROCEDURE CollectionsSetNote 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(IN pCollectionID CHAR(20), IN pStaffID CHAR(20), pChatNote long VARCHAR)
RESULT( presult CHAR(250))
BEGIN
   CALL AuditLog('COLLECTION',pcollectionid, 
    string('Collection Notes Changed - ',(SELECT name FROM collection WHERE collectionid=pcollectionid)),(SELECT notes FROM collection WHERE collectionid=pcollectionid),pChatNote);  
 UPDATE collection SET notes =  pChatNote WHERE collectionid = pcollectionid;
END
}