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!!