Search options (Page 14 of 16)

Wow. Looking forward on the new development of MVD. <3
Is there an estimated date of releasing it?

I think passing object value to combobox filter is not yet supported. I've used the dbSQLExecute and/or changing Combobox.dbFilter via script in my projects.

Hope MVD team respond with the issue. I haven't seen post of 'em lately.

You need to populate the component table with the same order of that array of Buttons.

You can use database GUI for that such as navicat(paid software) or DBBrowser, etc. for you to populate it

Or you can use the import function of MVD. See import.png on the zip. I created components.csv based on your array. Make sure to Clear the Component first before doing an import. You can skip the 4th column of the csv for it is your reference. You can edit Column 2 and 3 for the benefit of your users. So that they can easily understand what to give access to other users.

Make sure that the order of the buttons/components in your database is the same in the button array from script

 ButtonArr : Array of TdbButton = [Form2.Button1, Form2.Button2, Form2.Button3, Form2.Button4, Form2.Button5, Form2.Button6, Form2.Button7, Form2.Button8];

If you copy the calculated Derek and I used, we use phone there for it is the field on our database. on User for Derek. on Contacts for me. You need to replace it of the field on your table. in your case,  change phone from User's calculated to CellPhone and change phone from the Contact's calcCellPhone to cCellPhone.

For User, something like

'('||substr(CellPhone,1,3)||')'||substr(CellPhone,4,3)||'-'||substr(CellPhone,7,4)

and for Contacts

'('||substr(cCellPhone,1,3)||')'||substr(cCellPhone,4,3)||'-'||substr(cCellPhone,7,4)

Adding calculated fields or other fields won't affect your current data. MVD will automatically populate the table with your existing records

Here's a sample.

Here's some changes

You mean the Admin User can set the access and not by the developer right?

I think, best way to do is:
- List down and plan thoroughly buttons or modules you want other user to access, then store it in database.
- Do it with script

I made some script, compiled it in version 6.4-beta. I hope it gives you an idea on how to work on your project. Cheers!

Just Just use the Role Option in the Button's Properties

My bad. I'm using 6.4-beta. You don't want to update yours? I tried reinstalling 6.3. It seems working to me.

Just use the form provided by mvd in creating users. It is accessible by Administrator users