SELECT
matno,
MAT_NAME,
rawpkgno,
MAX(SWITCH(deldate=? ,ORDCASES )) AS [CURRDATE],
MAX(SWITCH(deldate=? ,ORDCASES )) AS [previous_day],
MAX(SWITCH(deldate=? ,ORDCASES )) AS [Last_date]
FROM
invorder
WHERE
invorder.strno =54009
OR [invorder.deldate] IS NULL
GROUP BY
matno,
MAT_NAME,
rawpkgno,
My ouput in gridview is as follows
matno MAT_NAME rawpkgno CURRDATE previous_day Last_date
Edit 1 REGULAR BUNS 0 125 11
Edit 3 BIG MAC BUNS 0 29
Edit 4 MAC FRIES 0 551 28
Now when I select edit I should be able to edit "CURRDATE".How can I do it can some one help me on this?