Posts

Progress 4gl interview questions

Q:- What is the diff between for first and find first? Ans:-  The difference between for first and find first is: 1. For is a progress block and find is a progress statement. 2. For first can use multiple indexes and Find cab use only one index. 3. For First fetch the data from record list and Find first fetch the data from record buffer. 4. Contain function cab be used by For First but not by Find First. 5. In for block u can use field clause, but in find statement u cant use field clause. 6. You cant use prev and next phrase with For block as like find statement. for first displays data without sorting while find first display data after sorting,So the for first is more efficient in terms of time taken for displaying the record as compared to find first. u can check this by using the ETIME() Function to check the time taken by these two  statements. Q:-  Is there a difference between a FIND and a FIND FIRST when the index is unique? Ans:- Yes, there is a difference. Even if a unique