I have a very odd question that I've never run into. I have an
application that implements security on a row and column level. This
is accomplished with an ancestor datawindow control that communicates
with a non visual object.
By the time the datawindow retrieves it knows the rows and columns
that it does not have access to. It then goes through and sets
disabled colors and borders for all of the columns that are not
accessabie. Finally it goes through and find the rows that do not
have permissions and sets, one by one, the colors and borders and
protects for each of these columns. All of this works wonderfully.
The problem is when I am working in free form. Since my cursor can
not be put into any column on that particular row I find that it is
impossible to scroll to it. Since I am using the Visual Libraries I
am able to do the Ctrl-Alt-D at runtime and see the underlieing
structure of the dw and I can see that the row is in fact there. I
can use the Ctrl-Alt-G for the datawindow and try to directly go to
that row. But no matter what I do it will never display if the
protect for each column is on.
My current work-around is to put a dummy column in the upper left
hand corner and never protect it. Now it works but this is VERY
kludgy and leaves me with an extra column that might be a little
confusing to the user. Not very professional at all.