Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting a Numeric value out of range when using view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01304392
Message ID:
01304403
Vues:
23
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform