Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Making a cursor ReadWrite in VFP6 not filling correctly?
Message
From
09/10/2001 02:09:24
 
 
To
09/10/2001 00:56:17
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00565810
Message ID:
00565816
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform