>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:
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 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.