>>>>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.
Thanks for the suggestion.
After nerrowing it down , I found the row in one of the table that was causing the problem.
Thanks all,
Greg Reichert