Subject | Read Only confusion |
---|---|
Author | Clive Walden |
Post date | 2006-03-07T21:02:01Z |
I have the following code that runs after a user logs on and before I open the datasets if the
user's ROLE indicates that their access is Read Only (and their ROLE gives them 'SELECT' privileges
only).
== snip ==
procedure TdmMain.MakeReadOnly;
begin
qryProjRevisions.RequestLive := False;
qryProjRevisions.ReadOnly := True;
qryRevisionCATs.RequestLive := False;
qryRevisionCATs.ReadOnly := True;
qryGetProjectsInfo.RequestLive := False;
qryGetProjectsInfo.ReadOnly := True;
end;
========
In spite of this, when I try to log on as such a user I get an error message which is strange in two
respects.
1. It tells me that I do not have Insert/Write permission to a Field in qryGetProjectsInfo.
(actually, something called qryGetProjectsInfo.IBOqrqryGetProjectsInfo)
2. The field that is subject to the complaint is not in qryGetProjectsInfo
it is in qryProjRevisions.
I have checked that the procedure MakeReadOnly
does in fact run before I attempt to open the TIBOQueries.
Thanks,
Clive.
Clive Walden
Walden Consulting
Phone: 760-632-5856
Web site: www.clivewalden.com
user's ROLE indicates that their access is Read Only (and their ROLE gives them 'SELECT' privileges
only).
== snip ==
procedure TdmMain.MakeReadOnly;
begin
qryProjRevisions.RequestLive := False;
qryProjRevisions.ReadOnly := True;
qryRevisionCATs.RequestLive := False;
qryRevisionCATs.ReadOnly := True;
qryGetProjectsInfo.RequestLive := False;
qryGetProjectsInfo.ReadOnly := True;
end;
========
In spite of this, when I try to log on as such a user I get an error message which is strange in two
respects.
1. It tells me that I do not have Insert/Write permission to a Field in qryGetProjectsInfo.
(actually, something called qryGetProjectsInfo.IBOqrqryGetProjectsInfo)
2. The field that is subject to the complaint is not in qryGetProjectsInfo
it is in qryProjRevisions.
I have checked that the procedure MakeReadOnly
does in fact run before I attempt to open the TIBOQueries.
Thanks,
Clive.
Clive Walden
Walden Consulting
Phone: 760-632-5856
Web site: www.clivewalden.com