Das Problem hat sich erledigt, war ein Problem mit der Componente.
Konnte es für den Moment so umgehen:
SQL-Code:
( MEMBER_GROUP = 'ADMIN')
OR (( MEMBER_GROUP = 'CAMP')
AND (CONDITION_VALUE = NEW.C_NO)
AND ('MEMBER' IN (SELECT ST.TABLE_NAME
FROM RPL$SERVICE S JOIN RPL$SERVICE_TABLES ST ON ST.SERVICE_NAME = S.SERVICE_NAME
WHERE S.SERVICE_NAME LIKE 'MEMBER' AND SERVICE RLIKE '[[:<:]]MEMBER[[:>:]]')
)
)
OR (NEW.C_NO IN (SELECT GR.CAMP_NO
FROM RPL$GROUPS G JOIN RPL$GROUPS_RIGHTS GR ON GR.GROUP_NO = G.GROUP_NO
WHERE G.GROUP_NO = MEMBER_GROUP)
AND ('MEMBER' IN (SELECT ST.TABLE_NAME
FROM RPL$SERVICE S JOIN RPL$SERVICE_TABLES ST ON ST.SERVICE_NAME = S.SERVICE_NAME
WHERE S.SERVICE_NAME LIKE 'MEMBER' AND SERVICE RLIKE '[[:<:]]MEMBER[[:>:]]')
)
)
Shalom
Manfred