>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.
If it's not broken, fix it until it is.
My Blog