How to OMA!

This week I had to rename a couple of records in a customized table. When I tried to do this I was getting an error like “You cannot rename a blahdieblah”. In a default Cronus database something similar is written in the OnRename trigger of the “Fault Code” table.

In life without OMA you’ll have to export this object as a fob, slash out this line of code, rename the record and import the fob. Or even worse if you’re license doesn’t allow you to modify the object you’ll have to write a report that renames the record.

With the OMA you can open this table in edit mode and rename the record. That’s all.

Please be careful in a live database because the OnRename trigger will not be fired so related tables will not be updated.

Look at this demo on YouTube!

This entry was posted on Thursday, June 14th, 2012 at 4:10 pm and is filed under Object Explorer, Object Manager. You can subscribe via RSS 2.0 feed to this post's comments. You can comment below, or link to this permanent URL from your own site. Your comments will appear immediately, but I reserve the right to delete innapropriate comments.