Hi Angela,
If you absolutely have to use SQL for a task (like minor_rev, as you mentioned), then creating a SQL item in the Aras database is probably the best way to go. You can reuse the same SQL across methods, maintain the SQL in one place, and you can package it up like any other method or configuration item.
A word of caution - not just for you, but also anyone else who finds this thread - modifying Aras data via direct SQL can have unintended consequences such as data corruption, data loss, or bypassing the permission model. It should be used only when there is no other option, and it should be tested extensively in dev/test environments before releasing to production. As you mentioned, AML and IOM are the preferred approaches for retrieving and modifying Aras data.
Eli
Eli Donahue
Aras Labs Software Engineer
