| | | StrataFrame Novice
       
Group: StrataFrame Users Last Login: 11/19/2008 3:34:49 PM Posts: 96, Visits: 886 |
| Hello
What is the best way to extend the SFSUser Table to add custom user fields (eg. EmployeeID, Title, Phone Numbers)
Thanks
MS Windows XP SP3
AMD Athlon 64 Processor 3000+
3,2 GB RAM, Radeon X1600/x1650 Series |
| | | | 
StrataFrame Developer

Group: StrataFrame Developers Last Login: 10/21/2008 9:20:58 AM Posts: 2,685, Visits: 1,887 |
| You best bet would probably be to add table to your database to store that information and tie the records to the SFSUsers table through the us_pk field. Then, you would just need to create a business object for that table and a form to allow the information to be edited/maintained.
www.bungie.net |
| | | | 
StrataFrame User
       
Group: StrataFrame Users Last Login: Yesterday @ 1:32:21 PM Posts: 368, Visits: 1,854 |
| I don’t know what others are doing, but as Ben suggests, I started out by adding a table to the data base to hold the additional user fields that contained a foreign key from SFSuser. As Ben would probably not recommend, I modified the SF user maintenance dialog by adding a tab to maintain the added info along with a BO that mapped to my new table. It looked and worked great, however keeping my version of Role Based Security in sync the SF release quickly got old. I ended up building my own “Additional User Info” maintenance screen that has the same look and feel of the SF user maintenance dialog. On my main form I have a User maintenance menu with “Security” and “User Info” sub menus to bring up the proper dialog. I also added some logic to AppMain that checks to make sure the additional user info fields are populated when the user logs in and exposes those fields via public properties of a static class. -Larry |
| | | | StrataFrame Novice
       
Group: StrataFrame Users Last Login: 11/19/2008 3:34:49 PM Posts: 96, Visits: 886 |
| Thanks for the advices
I was thinking of two approaches:
1) Creating a separate security assembly that contains the custom field depending on client request (I did it similar when enhacing the inherited ui assembly for a third party control suite not supported) it will be easier to maintain between StrataFrame releases.
2) The approach of creating another table at application level.
what do you think?
MS Windows XP SP3
AMD Athlon 64 Processor 3000+
3,2 GB RAM, Radeon X1600/x1650 Series |
| |
|
|