🚀 go-pugleaf

How come HasAccess  and OptCode are read only in my dataset while everything
else is editable?

CREATE PROC UserGroupAccess_lst
@UserGroup  VARCHAR(10)
AS
SET NOCOUNT ON

DECLARE @OpCode INT
SELECT @OpCode = 0

 --* return the all the functions and an indicator on those
 --* that the group has access to
 SELECT DISTINCT
  b.ModNbr,
  b.FuncNbr,
  FunctionName,
  HasAccess = CASE WHEN EXISTS ( SELECT  *
      FROM  AccessRights c
      WHERE Group_Cd = @UserGroup
      AND c.FuncNbr = b.FuncNbr)
     THEN 1
     ELSE 0
    END,
  'OpCode' = CONVERT (VARCHAR(20),@OpCode)--field for client use
 FROM ModuleAccess b
 LEFT JOIN AccessRights a ON a.FuncNbr = b.FuncNbr



/*************** Testing Area *******************************

UserGroupAccess_lst 'ADM'
sp_helptext usergroupaccess_ins

usergroupaccess_ins 'adm', 100, 103


select * from accessrights
select * from moduleaccess
select * from usergroup
select * from contacttype

*************************************************************/



/************** Modification Log *****************************
24-Oct-2001 JR -Initial version
31-Oct-2001 JR  -LEFT Join and add a HasAccess field so clients
  -gets all information in one call.  Also added
  -OpCode field for client use.




*************************************************************/