I'm very new (less than 5 total days working time) to Alpha Five. I have experience using SQL Server and .NET but have been told I need to learn A5 (version 9). So I built a demo database to mess around with and get my feet wet. It's a student/professor/class layout (pretty simple).
What I want to do is when the user starts A5, I want them to put in a username/password combination. That combination will tie them to a particular "user level" (in my example it's Administration, Student, Employee). Depending on that level, they will be permitted to only do certain things.
I was thinking (again, this is coming from a .NET mentality) that I would set two variables (one logical (logged in or not) and one character (user type)). Then depending on those variables, the user will see a menu bar. If they are Administration, they can see everything. If they are a student, then can only see certain items (having the other items disabled somehow).
I've included a .zip of the database (I hope I'm on the right path) and an example of what I was thinking of for the login screen.
Is this possible? Extremely difficult? I've searched for "login" on the boards but most (all?) examples seem to point towards using the Web server. I'm not using the web server. Is this doable on the Desktop version? Is this most likely too advanced for a newbie? Also, I'm not really sure of XDialog, ActionScripting or XBasic - which would be more appropriate for what I'm trying to do? I was thinking I would just write a regular SQL script with a return value of 0 if no match or the userlevelID (1, 2, 3, etc) for a match. But I'm not really sure where I would write that.
Any pointers, tutorials, examples, etc would be greatly appreciated. Thank you in advance for any help you can offer. In the mean time, I'll be working through the examples I can find online.
What I want to do is when the user starts A5, I want them to put in a username/password combination. That combination will tie them to a particular "user level" (in my example it's Administration, Student, Employee). Depending on that level, they will be permitted to only do certain things.
I was thinking (again, this is coming from a .NET mentality) that I would set two variables (one logical (logged in or not) and one character (user type)). Then depending on those variables, the user will see a menu bar. If they are Administration, they can see everything. If they are a student, then can only see certain items (having the other items disabled somehow).
I've included a .zip of the database (I hope I'm on the right path) and an example of what I was thinking of for the login screen.
Is this possible? Extremely difficult? I've searched for "login" on the boards but most (all?) examples seem to point towards using the Web server. I'm not using the web server. Is this doable on the Desktop version? Is this most likely too advanced for a newbie? Also, I'm not really sure of XDialog, ActionScripting or XBasic - which would be more appropriate for what I'm trying to do? I was thinking I would just write a regular SQL script with a return value of 0 if no match or the userlevelID (1, 2, 3, etc) for a match. But I'm not really sure where I would write that.
Any pointers, tutorials, examples, etc would be greatly appreciated. Thank you in advance for any help you can offer. In the mean time, I'll be working through the examples I can find online.
Comment