Hide a row or a specific record in frmdbCoreUserForm

As soon as you find the help hidden on the MVD website, from the very first page
you will discover magical DELPHI spells and formulas hidden from prying eyes and protected by DriveSoft.
Take care of the secret of Row and RowVisible, just as DriveSoft takes care of it.

Vladimir didn’t keep the secret. )

Hi,
The name of the grid is 'frmdbcoreusers.gridusers'
However, I can't find any reference to the name of the 'role' combobox on 'frmdbcoreuserform'.  I wrote a small program a while back to identify all the elements on the 'frmdbcore' suite of forms and the one element that it never found was the 'role' combobox which is puzzling.
Derek.

Hi all.

The combo is created on the form when the form starts.
You can refer to it as components[21]

Well... I cannot get anything working to manipulate at least the frmdbCoreUserForm.combobox to not display the role with id=3

I have tried all number in components[] without a result.

This is where I am at:

 frmdbCoreUserForm.components[21].dbFilter:= 'id IS NOT 3';

and the error is always Undeclared identifier:'dbFilter'.... whichever the number

Yeah, actually I renamed the topic since we cannot interact with the frmdbCoreUsers.gridusers and actually it makes no sense to play with it since  the main issue is in the role combobox filtering in the frmdbCoreUserForm.

If the application has been compiled with a specific role and the role is deleted from the database afterward via sqlitestudio to hide it, the role will reappear in the database with a new id at next app launch. I do have buttons and fields reserved to developer in my app and I want to avoid anyone else to play with them. Without this restriction I must keep 2 versions of the app, 1 with the hidden dev features as well as no dev permissions and 1 without any of the dev features which is cumbersome.

It looks like the frmdbCoreUserForm combobox is a dynamic component and I don't get how to filter it.

Hi Sparrow,
I understood this part, the problem is to know what is the name or the component reference of this combo!
There must be a reference to this combo somewhere, otherwise it could not exist or is there a trick to address an unnamed component in a form?

But it does not work as I always get the error "Undeclared identifier:'dbFilter'.... " whichever the number.

At the end of the script before the final end.

I put

 frmdbCoreUserForm.components[21].dbFilter:= 'id IS NOT 3';

and it does not compile with the error "Undeclared identifier:'dbFilter'.... "

Hi,

Thank you so much Derek for taking the time despite your busy schedule to explain something that is simple to most of advanced developers but still is a work in progress for most of us. It works great, basic is the best!!

I have read many articles about this solution in other forums but they were all context specific with no clear explanation  and I could not understand how to apply it to My Visual Database since I am not (yet) a Delphi programmer. I bought some Delphi books but I just started them...