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



Updating MessageKey field....Expand / Collapse
Author
Message
Posted 04/24/2007 1:29:52 PM


StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: StrataFrame Users
Last Login: 07/09/2008 2:20:16 PM
Posts: 436, Visits: 944
As you can see in the image below I have chose MessageKey for the Denied Action and specified a MessageKey. What I would like to do is change the message key for all 100 of my permission items. I was wondering if you could point me to the table that this information is stored in so I could use T-SQL to update the table rather than doing each one individually.



Thanks
Post #8469
Posted 04/25/2007 9:03:41 AM


StrataFrame Developer

StrataFrame Developer

Group: StrataFrame Developers
Last Login: Yesterday @ 1:09:23 PM
Posts: 2,686, Visits: 1,888
Yep, it's the SFSPermissions table.  The two fields you'll be interested in are pm_BlockedAction which is an INT field with a value corresponding to the DeniedActions enumeration.  And the other field is pm_BlockedMsgOrKey which is NVarChar(1000) and contains the value you want to change.


www.bungie.net
Post #8484
« 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 8:55am

Powered by InstantForum.NET v4.1.4 © 2008
Execution: 0.047. 10 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.