I have a issue when replacing data into my cursor.
Code:
IF thisform.cboBatchType.DisplayValue= 'Pending GRN'
SELECT ACPGRN
GO TOP
REPLACE ALL cGRN WITH 'Awaiting'
ELSE
IF ACPGRN.nPoQty>ACPGRN.nGrnQtyVal THEN
SELECT ACPGRN
GO TOP
REPLACE cGRN WITH 'Awaiting'
ELSE
SELECT ACPGRN
GO TOP
REPLACE cGRN WITH 'Completed'
ENDIF
ENDIF
According to this I need to be my cursor as below.
Code:
nPoQty nGrnQtyVal cGRN
123 758 Awaiting
45 20 Completed
56 36 Completed
865 11256 Awaiting
How can I get like this output according to the above logic?
Thank you