Had any numeric columns definitions in SQL table been changed recently?
>I have created a database that has a connection to an SQL Server database. I created a view called 'Item' to be SELECT * from a table of the same name on the SQL Server database.
>
>I use the view inside a VFP program to check for records to be present or not.
>
>Lately while the program is running I get an error of:
>
>Connectivity error: [Micrsoft][Odbc SQL Server Drive] Numeric value out of range
>
>It does not tell me which field and there is no way I can figure out what is causing the problem.
>
>Does anyone know why I would be getting this error in a view created from a Connection to an SQL database?
>
>Does anyone know how I can trace the error back to the field or problem area causing this error?
>
>TIA
--sb--