Here's my recycle function:
LOCAL lcDelete,lcOldOrder
lcDelete=SET('DELETE')
lcOldOrder=SET('Order')
SET ORDER TO
SET DELETE OFF
LOCATE FOR DELETED()
IF NOT FOUND()
APPEND BLANK
ELSE
RECALL
BLANK
ENDIF
SET DELETE &lcDelete
SET ORDER TO &lcOldOrder
This is usually working fine but not on a specific case and here it is.
If I have a child grid which is based on a the form parent alias. My ChildOrder, LinkMaster & RelationExp child grid properties represent the relation. When I add a record, I execute this recycle function to know wether or not to recycle a record. After this call I then replace my parentid of the child table with the parent.parentid. When using the APPEND BLANK, the grid refresh and show the new added record. If the system find a record the recycle then I only see that record until I click on the scrollbar.
Why is my RECALL giving me this behavior? I can't seem to find a workaround for this but to avoid the RECALL.