>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).