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.