>A number of UT members use xCase data modeler. I am new to xCase and have a question not answered in their help file. So...
>
>1. Are there any xCase user forums on the web? Any other support materials or developer resources on the web other than the Resolution website?
>
>2. xCase will automatically create triggers but only if there are RI issues (if there is a table relationship). I need to add trigger code to EVERY table (updating the updatedBy and updatedWhen fields). I've added the necessary code to the trigger footers and this is working for tables that have relationships defined in the data model, but how can I get xCase to generate triggers on tables without relationships?
>
>Note: I realize that sending code to the SQLDMO could help me, but the cleanest solution in our situation is to get xCase to do the work -- it is generating the rest of our trigger code.
>
>Thank you for any help you can offer!
>
>- Ed

Can't help you with the first question, but on the second, xCase will hold the code for non-RI triggers just like it does for stored procs. However, you will have to add that manually.

Having said that, remember that xCase uses good ole' Fox tables to hold everything. If you have a consistant naming routine (such as every table has the same two columns with the same two names) it would be fairly easy to write a Fox routine that populates the code into the xCase trigger table. That way you have it in there the next time you need to update the database.

Just an idea...