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.