Dialog - cerate an account for a new user - no user role

[Malcolm]

Hi,
I've watched the video D_SF_1 now a large number of times and when I get the the end of the process 'working preview' allows me to enter a new user name and password correctly. The new user appears as in the Users and Groups genie, but no role is defined.

I thought this must be because the hidden 'UserRoles' control wasn't bound properly. I looked at the 'Data Binding - Specify Tables' dialog, expecting to see my websecurity.dbf table, but alas the table pane was bare! Selecting Table type = dbf failed to display the security tables. Probably as a result, the 4 fields (UserPassword, UserConfirmPassword, UserRoles and UserGuid) have no table alias or fields shown in the 'data binding' table. The 'UserRole' default value property is also blank - as I believe it should be.

I also tried creating the second of the web security dialoges - 'create new user account and add user information to an existing table.' In this example I also found difficulty in binding the fields. There is nothing on the videos about specifying the tables to which the personal data is going to be mapped. When I add my SQL connection string and attach the user table to the RegisteredUsers dbf table, I get the Error message below.

WebSecurityTableBindingError.PNG

I am using an Access backend, A5 V11 and have about 60 users already set up and operating happily on the web server. The problem has only arisen because I am now needing to change some user roles. I'm trying to get around having to import the server security tables for every user I want to change.

I've read a fair few other threads, some of which point to some elaborate solutions to custom set-ups. Mine is a very basic structure that doesn't deviate from the videos at all - no code whatsoever, and shouldn't need any special tratment (I hope).

Although this seems simple to write down, it may not be simple to follow. The video link shows the second data-binding error in another way.

http://screencast.com/t/Rlc3PwBacK0

Many thanks for any help from those who have gone here before. Malcolm

[Keith Hubert]

Re: Dialog - cerate an account for a new user - no user role

Hi Malcolm,

If I watched your video correctly, you show an sql connection string to the RegisteredUsers table which you say is dbf. That does not seem right to me.

[RhinoSmith]

Re: Dialog - cerate an account for a new user - no user role

Malcolm-
I believe Keith is right. You need to delete the "RegisteredUsers" table then add your "RTLBDetails" table if that is where you are storing your user information. Then go from there.

Hi,
I've watched the video D_SF_1 now a large number of times and when I get the the end of the process 'working preview' allows me to enter a new user name and password correctly. The new user appears as in the Users and Groups genie, but no role is defined.

I thought this must be because the hidden 'UserRoles' control wasn't bound properly. I looked at the 'Data Binding - Specify Tables' dialog, expecting to see my websecurity.dbf table, but alas the table pane was bare! Selecting Table type = dbf failed to display the security tables. Probably as a result, the 4 fields (UserPassword, UserConfirmPassword, UserRoles and UserGuid) have no table alias or fields shown in the 'data binding' table. The 'UserRole' default value property is also blank - as I believe it should be.

I also tried creating the second of the web security dialoges - 'create new user account and add user information to an existing table.' In this example I also found difficulty in binding the fields. There is nothing on the videos about specifying the tables to which the personal data is going to be mapped. When I add my SQL connection string and attach the user table to the RegisteredUsers dbf table, I get the Error message below.

[ATTACH=CONFIG]34074[/ATTACH]

I am using an Access backend, A5 V11 and have about 60 users already set up and operating happily on the web server. The problem has only arisen because I am now needing to change some user roles. I'm trying to get around having to import the server security tables for every user I want to change.

I've read a fair few other threads, some of which point to some elaborate solutions to custom set-ups. Mine is a very basic structure that doesn't deviate from the videos at all - no code whatsoever, and shouldn't need any special tratment (I hope).

Although this seems simple to write down, it may not be simple to follow. The video link shows the second data-binding error in another way.

http://screencast.com/t/Rlc3PwBacK0

Many thanks for any help from those who have gone here before. Malcolm

[Malcolm]

Re: Dialog - cerate an account for a new user - no user role

Thanks for your responses.

If I'm correct, controls in the first of the dialogs which is intended to add a username and password to the security system need to be bound to the table where the username, passwords and security 'roles' are stored. I thought this was the RegisteredUsers.dbf table. But the data binding shows NO table and NO fields in this setup. I show this in the vid below.

The second security dialog captures data for both the security table and my 'users' table. The binding genie defaults to show the RegisteredUsers table (to which the Username, Password, Role and Guid are to be bound) and Ithink needs me to link my 'users table' so that I can bind other controls in the dialog to that.

It is here that I believe I need to make the SQL connection to my user table. This all seems pretty logical to me, but somehow not to Alpha. (My experience tells me who is most likely to be correct!)

I've again shown how I go through the setup for both dialogs in the linked vid. Can you see where I'm going wrong?

Thanks again for the time you spend on this - much appreciated.

http://screencast.com/t/oAS3UJDL

[iRadiate]

Re: Dialog - cerate an account for a new user - no user role

Malcolm,

It's been a while since I've looked at this, but as I recall the Username, Password, Roles, GUID should be unbound as this is handled through the Alpha security system.
You need to tell these to be unbound with "Set selected fields to *unbound"
I have a separate table that holds information I want access to such as username, Firstname, Lastname, etc.

Here are a few screenshots of how I have this setup:
First I have a table called employees to hold info I want to see
1. Employees table.png

I bind those fields in the dialog to my table and leave the security stuff unbound
2. Binding.png

When I save the dialog, the security values are assigned in the server side afterdialogvalidate event
3. Submit.png

And finally here's how I have it laid out in the Dialog
1. Dialog.png

I hope this helps somewhat. As I say I did this quite some time ago, so it's not exactly fresh in my memory.

Stephen

[iRadiate]

Re: Dialog - cerate an account for a new user - no user role

Oh, and here is the GUI as the user sees it:

GUI.png

[Malcolm]

Re: Dialog - cerate an account for a new user - no user role

Thanks for delving back into the archives Stephen. I've now got the dialog entering data into the Users table (via the SQL connection string) by removing the 'RegisteredUsers' table that popped up automatically, but somehow the dialog is still not binding to the security tables. The same is true for all three of the dialog set-ups when I work through the vids.

What you've got is where I'm heading! It looks great.

I'll keep exploring various options and hopefully will come up with some way of modifying user security - online.

Thanks again. Malcolm

[RhinoSmith]

Re: Dialog - cerate an account for a new user - no user role

Malcolm-
I created a little video of going quickly, though not exhaustively, through setting this up. Though, it seems you have been able to add to your table. I'm not sure why it would add to your table and not the security tables though.

http://screencast.com/t/MXbldRSh696F

Thanks for delving back into the archives Stephen. I've now got the dialog entering data into the Users table (via the SQL connection string) by removing the 'RegisteredUsers' table that popped up automatically, but somehow the dialog is still not binding to the security tables. The same is true for all three of the dialog set-ups when I work through the vids.

What you've got is where I'm heading! It looks great.

I'll keep exploring various options and hopefully will come up with some way of modifying user security - online.

Thanks again. Malcolm

[Malcolm]

Re: Dialog - cerate an account for a new user - no user role

Thanks for that Chris, your vid has pointed me to where I think the problem is.

I worked through exactly the same steps as you've taken me through and the difference is in the 'databinding' of the Control Properties. The very bottom propert section of the UserPassword control - Data Binding - is missing several lines. It shows the Updateable box as unchecked, but the three other properties shown in your example; Table alias, FieldName and Null if blank are missing.

All the field binding detail is EXACTLY as shown in your example. It seems to be a case of security tables 'missing in action.'
More reading is needed. I'll keep you posted.

[Cristiano]

Re: Dialog - cerate an account for a new user - no user role

Thanks guys,

all more clear, but If I would like to give the possibility to the administrator to create/modify/deleting users directly from the web app? without any intervention of the Alpha fivedeveloper ? (give too our clients a STAND ALONE web application ) It's not neccessary to implement something also for the web security members ?

Thank you