Hi Jim,

The cursor created with SQl Select is read only but it allows to create one structural index. To make it Read/Write

SELECT ... INTO CURSOR mycursor
USE ( dbf("mycursor")) in 0 AGAIN alias temp1
USE IN mycursor
USE ( dbf("temp1")) in 0 AGAIN alias mycursor
USE IN temp1
SELECT mycursor

In VFP 7 you can just add READWRITE clause to you select.


>I am trying to create a cursor and update it with values. I must use a cursor because it is a read-only set of data that many users can generate at the same time on a network. (They will not clobber one another's data if cursors are used). I was pulling the cursor with 'select - SQL' with the totals as 'TotAmt as 000.00' (in order to build a total which would be later filled in) and then trying to replace that field later with a value. I have been able to update cursors and even index them in the past, but I don't remeber what makes a cursor updatable or how I did it. I won't be using 'cursorsetprop()' because that is for views - correct?