>>>Hi All,
>>>
>>>Recently I have been assigned an application that throws an error on occations. The problem is in the Data Environment, where it opens a dozen or more remote views. One (or more) of these RV is reporting a SQL Server error "Conversion failed when converting the varchar value '.' to data type int."
>>>
>>>I have openned each of the views manually, and don't receive the error. It only happens when the form opens the views.
>>>
>>>Is there a way to trace the openning of the views so I can identify which one is throwing the error?
>>
>>You need to fix the select statement for this RV. Do you know which RV causes the problem? Can you post SQL for each of them - I can tell which one is failing.
>>
>>It's also possible that you have mismatch in fields used in JOIN condition.
>
>I recently inheritied the application. Over the years many people have had their hands in it.
>
>There are 19 RVs. I have no problem openning (Browse) these RV, But when the form opens them via the Data Environment, I receive the error. I am looking for a means to step through the openning procedure of the RV so I can identify which one is causing the error,

Put some assert code in BeforeOpenTables method of DE.