>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 opened 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 opening of the views so I can identify which one is throwing the error?



Usually this error is received when you have RV that uses parameters and pass wrong type of parameter.
Something like:

** RV Select statement
** SELECT * FROM SomeTable WHERE MyField = ?mypar

myPar = 1
REQYUERY("MyRV")

The above code will be run OK IF MyField is some of the numeric types and IF it is some type of CHAR and ALL values can be converted to numeric.
So is you have this data in SomeTable:

MyField varchar(200)
---------------------
1
2
123
5433

everything will be OK

BUT

MyField  varchar(200)
-----------------------
1
2
123
5433
.
asdasd
blah

and you are doomed :-)