pears.CollectionsGetUsers

CREATE PROCEDURE "pears"."CollectionsGetUsers"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pCollectionID" CHAR(20) ) 
RESULT( "CollectionUserID" CHAR(20),"CollectionID" CHAR(20),"StaffID" CHAR(20),"StaffName" CHAR(60),"UserID" CHAR(25),"shortid" CHAR(2),"Notes" CHAR(100) ) 
BEGIN
  SELECT "CollectionUserID","CollectionID","Staff"."StaffID","staff"."Name" AS "StaffName","staff"."userid","staff"."shortid","CollectionUsers"."Notes"
    FROM "CollectionUsers","Staff" WHERE "collectionID" = "pCollectionID" AND "CollectionUsers"."staffid" = "staff"."staffid" ORDER BY "userid" ASC
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."CollectionsGetUsers" IS 
{CREATE PROCEDURE CollectionsGetUsers 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
(  IN pCollectionID CHAR(20))
 RESULT(CollectionUserID CHAR(20) ,  CollectionID CHAR(20), StaffID CHAR(20), StaffName  CHAR(60), UserID CHAR(25), shortid CHAR(2), Notes CHAR(100) )  
BEGIN 
	SELECT CollectionUserID, CollectionID,Staff.StaffID, staff.Name AS StaffName, staff.userid, staff.shortid, CollectionUsers.Notes 
         FROM CollectionUsers ,  Staff WHERE collectionID = pCollectionID AND  CollectionUsers.staffid = staff.staffid ORDER BY userid 
END
}