>>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,
Greg Reichert