What is odd is that this is a view in a VFP database.
So I can just open the database and say USE ITEM.
I set it so that all records come over at once, so I get 32000 records to use. I have done LOCATEs and SCANs in this view previously and have had no problem, but now it is hanging on this error at the same place all the time. The ITEM table is open and I am sitting on a specfic record. I can ask it to display certain fields on that record by using ? ItmCog and this works, but I cannot browse the table when the error occurs and I cannot skip -1 or skip forward. I can tell the program to ignore the error and the program continues on with no problem.

I will display every numeric field there is and get back to you.

>>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.