>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
Just before TABLEUPDATE() the view put a BROWSE NORMAL for it.
Go through records and check for anomalies like ********, HUGE values as 2339999999999700 in some fields, Values bugger than 2147483647 or smaller than -2147483647 in integer fields.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.