Sweet!

If you're running at runtime, just pass 0 to the method.  The ProjectPK is only used at runtime, and if you pass 0, then it is completely left out of the WHERE clause.

Sometimes answers lead to more questions! HA HA

The FillAll method of the SFSPermissionsBO requires a ProjectPK in order for it to work. Is there a way that I can programmatically retrieve that value so that I dont have to hardcode it into my app?

Thanks

THIS IS AWESOME! Thanks for all your help!

You can drop an instance of the SFSPermissionsBO on your form (you'll have to manually add it to the toolbox).  Then, just create a browse dialog like you normally would by searching off of the SFSPermissionsBO object.

This is great! I'm really excited about getting this to work! Unfortunately I'm just not exactly sure how to excute what you're telling me. I'm sorry it's just not clicking today.

Could you give me some steps please?

It is in the MicroFOur StrataFrame Security.DLL.  The namespace is MicroFour.StrataFrame.Security.BusinessObjects.SFSPermissionsBO.  It may not appear in the search list as we supress this from showing up, so you can choose another BO then open the .Designer.vb file and replace your selected BO with the namespace above and you will then be able to get to the fields, etc.  The type editors just hide our internal BOs by default so they don't show up in all of your BOs when searching.

Great! Where do i find SFSPermissionsBO?

It makes no sense to distribute the StrataFrame database and have to maintain your permissions in two databases.  Just create a browse that uses the SFSPermissions BO in security.  Then just create two search fields for the pm_Key and the pm_Description fields.

The type editor will never work in your scenario as the type editor relies on design-time interfaces that cannot be provided at run-time.  It is impossible to use any SF type editors at run-time.

Yes I believe I'm looking for more of a browser functionality.

We're using StrataFrame to develop in-house applications and we won't be distributing them outside our company. So, if we have the StrataFrame databases on our "production" server what would be the easiest way to browse the RBS keys? Is there a view I could create?

I'm not looking to create/modify, etc RBS without the aid of the your built in editors but I would like to be able to browse them because I have a RBS Key Field in a table. This way when I'm adding records I dont have to remember the name of the keys I can just look them up and have the name inserted into the field.

;-)