>I'm running a select that I need to be updatable. This is the code:
>
>
>SELECT inventory.stocknum AS stocknum;
>FROM Tomparco!inventory AS inv_this_trans;
>INTO CURSOR inv_this_trans;
>WHERE inv_this_trans.trans_id = trans_num; &&trans_num is a variable
>ORDER BY inv_this_trans.stocknum
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>if I run the following, I get the error "cannot update the cursor"
>

Hi. You can't to make SQL SELECT cursor updatable..
Solution.
1) Use updatable Local view
2) SELECT .... ;
INTO TABLE c:\mytable.dbf
Select will create updatable vfp table. But you can't update base data source without custom code.
3) Wait for VFP7. I hear updatable cursors will standart feature for VFP7 ;)

Denis