Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Making a cursor ReadWrite in VFP6 not filling correctly?
Message
De
09/10/2001 02:09:24
 
 
À
09/10/2001 00:56:17
Peter Brama
West Pointe Enterprises
Detroit, Michigan, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00565810
Message ID:
00565816
Vues:
19
>It was recommended awhile back that I use a cursor for my data instead of a temporary database file. At the time, I never changed what I had but now I am trying to. I need it to be read/writeable so I can edit a fields data for this "session". It was recommended I check the FAQ about RW cursors in VFP6. I did, and I entered the code. It works, sort of. Here are the lines of code:
>
>select sku as fSkuOur,desc as fDesc,price as fPrice,vend_id as fSkuVend,qty as fQtyIn," " as fQtyPrn from product into cursor cTemp
>USE DBF("cTemp") IN 0 AGAIN ALIAS cProd
>
>The select, does fill the cursor properly. When the cProd is created, it has one records data repeated throughout all 1800+ rows of the cursor. What happened???

Try adding a NOFILTER clause tou your SELECT statment. If you do a DISPLAY STATUS, I think you'll find that cTemp is only a "filtered view" of the table, and not a separate file (xxxxxxxx.TMP).
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform