I have a view form in remedy that is accessing a SQL server database on a remote server. My question being. I cannot modify the data on the View Form. Everytime I do that I get a SQL Server Error saying : "Unable to start a nested transaction for OLE DB provider 'SQLOLEDB'. A nested transaction was required because the XACT_ABORT option was set to OFF. (SQL Server 7395)"

Was I supposed to be setting the XACT_ABORT on. If so where do I do it, in the ar.cfg file ?

Obviously I am missing something here. I guess my basic Q would be can I enter new data and modify existing data using the View Form. If so how do I do it.

Thanks.

Hi...

As far as I know, a view-form can be viewed and only reads are possible towards the view-form.

However if you do a modify, submit or delete to an entry in a view-form nothing will happen automatically. I guess you will get an error for this, because the view-form is read-only.

But you can write workflow in the form of filters which catch the write-operations you are trying to do (modify/create/delete). These filters have to translate your operations in the view-form to operations towards the underlaying data on which the view-form is based.

This is my understanding of it.

-----
Quick