🚀 go-pugleaf

So I set them to readonly = false.  Now I get an error

EOleException msg 'Multiple-step operation generated errors. Check each
status value'

any idea's?


"Dale" <Dkrebbers@cenadex.com> wrote in message news:3be17085_1@dnews...
> 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.
>
>
>
>
> *************************************************************/
>
>
>
>