My Visual Database — Edit User Data

Re: Edit User Data

null@example.com (asawyer13) — Sat, 05 Dec 2020 18:04:43 +0000

Brian,
Worked perfectly.

Thanks

and the other suggestions too are now in my toolbox..

Alan

Re: Edit User Data

null@example.com (brian.zaballa) — Sat, 05 Dec 2020 02:46:36 +0000

ehwagner wrote:

Derek, Alan,
Or you could use one line of code to retrieve the record without going through a tablegrid. See attached.

I'm about to do something like this. Anyway. if you already have that frmUser form. You can open it and change Form1

frmUser.ShowRecord('_user', Application.User.id); // current logged on user

Re: Edit User Data

null@example.com (ehwagner) — Sat, 05 Dec 2020 01:49:19 +0000

Derek, Alan,

Or you could use one line of code to retrieve the record without going through a tablegrid. See attached.

Re: Edit User Data

null@example.com (derek) — Sat, 05 Dec 2020 00:39:18 +0000

Hi Alan,
I would take the userid of the person who has logged on, copy that to form1.edit1 which is then used as the value to filter the tablegrid down to a single record. The script then clicks the 'edit' button and displays the first and last names of the relevant user.
I've added an optional line to the script which hides the menu bar if the user does not have administrator privileges but you might already be doing that another way.
In the attachment, all passwords are the same as the userid's.
Derek.

Re: Edit User Data

null@example.com (asawyer13) — Fri, 04 Dec 2020 23:28:22 +0000

Would it be best to use the sqlexecute technique to load the grid with the one row i want?

Re: Edit User Data

null@example.com (asawyer13) — Fri, 04 Dec 2020 22:37:21 +0000

Derek,

Thanks,

How can I add a filter so that when there are many rows in the table like _user to only filter for the current logged in user?

Alan

Re: Edit User Data

null@example.com (derek) — Fri, 04 Dec 2020 22:10:21 +0000

Hi,
For me, the easiest way is to continue using a grid - even if there is only record, it doesn't matter.
However, if you want to make it more user friendly, just make the grid and the edit button invisible.
So you'd use a script to
1. highlight the only record in the grid
2. click the 'edit' button
Please see the attached.
There are other ways (using an editable grid is a 'no script' option) but I think this stays closest to basic MVD functionality.
Derek.

Edit User Data

null@example.com (asawyer13) — Fri, 04 Dec 2020 20:53:55 +0000

This might be a dumb question, but every sample app I look at uses a Grid to show the records and then you either double click or select Edit to modify the data.

How does one edit a record when there is only one record, or only one record that the user sees, for example, how does the user edit his first name and last name on his _user record when using roles?

I have a form called frmUser that has the fields but I don't understand how to load the data into it??? Is the best way onShow to grab the data for the user and put it in the text boxes, etc??? or is there a better way?

Thanks
Alan