Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting a Numeric value out of range when using view
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01304392
Message ID:
01304403
Views:
24
>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.


Views are always stored in VFP database, no matter which Local or Remote. BTW You use VFP9 why you still use views? There is a beautiful class CursorAdapter wich is more powerful that views, but that is your choice.
That error occurs when you use TABLEUPDATE() it that view is Table Buffering. If you use Record buffering that error occurs when you change record pointer. So if you use Record buffering change it to Table one and add explicit TABLEUPDATE() when you want to save records and before that put BROWSE NORMAL.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform