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 00:56:17
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Making a cursor ReadWrite in VFP6 not filling correctly?
Miscellaneous
Thread ID:
00565810
Message ID:
00565810
Views:
46
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???
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Next
Reply
Map
View

Click here to load this message in the networking platform