| | | StrataFrame VIP
       
Group: StrataFrame Users Last Login: Yesterday @ 10:01:58 PM Posts: 1,268, Visits: 3,234 |
| I need to load the an instance of the SFSRolesBO with all the roles from the security project used by the application. While I can look at the table and figure out what the ID it, it would be much better to just reference the ID used by the security system. How do I do that? |
| | | | 
StrataFrame Developer

Group: StrataFrame Developers Last Login: 09/26/2008 8:30:36 AM Posts: 2,685, Visits: 1,886 |
| You can call the FillAll() method on the SFSRolesBO object and pass it a project pk of 0. At runtime, there are no project pks... the SFSProjects table does not exist in the runtime database, and the tables are assumed to have records from only one project.
www.bungie.net |
| | | | StrataFrame VIP
       
Group: StrataFrame Users Last Login: Yesterday @ 10:01:58 PM Posts: 1,268, Visits: 3,234 |
| Ah. That's important to note. I took a look at the script that can be used to create the security tables (download link from security help file) to try to wrap my head around this a bit better and I noticed that some tables that have the sproj_pk column (prefixed of course) have a default of 0 and some don't (SFSRoles, SFSPermissions and SFSRestrictions). Is the script wrong or are these columns updated otherwise?
|
| |
|
|