In VFP7/8 you can just add READWRITE clause to the query. In VFP6 and earlier

SELECT iItemID, iSecUnitID, SUM(yQty - yClrQty) AS yQty, iSID ;
  FROM TempLKuInqQuotUnClr ;
  WHERE (yQty - yClrQty) # 0 ;
  GROUP BY iItemID, iSecUnitID, iSID ;
  INTO CURSOR temp NOFILTER
USE ( DBF("temp" ) AGAIN IN 0 ALIAS LKuInqQuotUnClrList 
USE IN temp

>Hi all
>
>I require to create a cursor for temporary purposes. This cursor is supposed to have atleast one field yQty that is required to be updated programtically.
>
>Is it possible? I tried creating a view out of it by adding CREATE SQL VIEW viewname AS .... followed by the SELECT statement that was working with INTO CURSOR cursname.
>
>

	CREATE SQL VIEW LKuInqQuotUnClrList AS ;
>		SELECT iItemID, iSecUnitID, SUM(yQty - yClrQty) AS yQty, iSID ;
>		FROM TempLKuInqQuotUnClr ;
>		WHERE (yQty - yClrQty) # 0 ;
>		GROUP BY iItemID, iSecUnitID, iSID

>
>now it does not create any dataset.
>
>Please advise.