How to find the last record from logical database. For ex., I have 'Get <db table1>' for getting the header details and 'Get <db table2>' for getting the item details corresponding to the first header. For each header, there are multiple items. I have to calculate the totals after the end of last line item. So, How to find the last item from second 'Get' statement.
When iam debugging, the cursor is going to first 'Get' to get the other header details once it completes all the line items.
Is there any statement to find the last record? Pls. help me regd this....
Thanx,
Vinod