StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Override Security Business Object Primary Key Values

RE: Override Security Business Object Primary Key Values

Isabella Miller — Sun, 04 Mar 2012 23:34:56 GMT

How can we adda trigger on the SQL table?

Override Security Business Object Primary Key Values

Aaron Young — Sun, 04 Mar 2012 23:34:56 GMT

Hi,

I have hit a problem with SQL replication and the Identity primary keys on the security BOs. Is there a way of trapping when a new security record is added and replacing the primary key value in program code. Ideally, I would like to avoid doing this through a SQL default column value and handle it entirely within the application.

Thanks in advance.

Aaron

RE: Override Security Business Object Primary Key Values

Trent L. Taylor — Thu, 08 Dec 2011 13:20:19 GMT

Well....not really on the client side. You could add a trigger on the SQL table to stuff the new PK into a temp table that you then turn around and query to pull from....but that may be more energy than you are wanting to get into.

RE: Override Security Business Object Primary Key Values

Aaron Young — Thu, 08 Dec 2011 11:35:18 GMT

Thanks Trent.

If I use the built-in StrataFrame.Security.SecurityDialog, is there a way of intercepting new records (i.e. a permission is assigned to a role) so that I can replace the primary key?

RE: Override Security Business Object Primary Key Values

Trent L. Taylor — Thu, 08 Dec 2011 09:56:25 GMT

Yes. You can set the BO properties as such:

PrimaryKeyIsAutoIncremented = False
PrimaryKeyIsUpdatable = True

If you are using the DDT, you will need to check "Primary Key Is Updatable" flag for that field so that the stored sprocs for the CRUD are created correctly.