StrataFrame Forum
Home      Members   Calendar   Who's On
Welcome Guest ( Login | Register )
      



How do I determine the SF security project ID...Expand / Collapse
Author
Message
Posted 01/24/2007 3:38:39 PM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: Yesterday @ 7:45:03 PM
Posts: 1,210, Visits: 3,074
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?
Post #6186
Posted 01/25/2007 9:12:49 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: 08/01/2008 8:53:41 AM
Posts: 2,671, Visits: 1,879
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
Post #6209
Posted 01/25/2007 11:04:15 AM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: Yesterday @ 7:45:03 PM
Posts: 1,210, Visits: 3,074
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?

Post #6234
« Prev Topic | Next Topic »


Reading This TopicExpand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Ben Chase, Trent L. Taylor, Steve L. Taylor

PermissionsExpand / Collapse

All times are GMT -6:00, Time now is 12:55am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.109. 12 queries. Compression Enabled.
Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.