May be
...
SKIP
IF EOF()
SKIP -1
MESSAGEBOX('END of table')
ENDIF
...
...
SKIP -1
IF BOF()
SKIP 1
MESSAGEBOX('Beginning of table')
ENDIF
...
>Our code performs on the skip logic on the parent table, so that the pointer to the child table is automatically reset to the matching record.
>
>>Which table parent or child ?
>>
>>>sorry, meant to say
>>>
>>>The code does not work when the table is EOF(), !BOF(), reccount() = 0
>>>
>>>
>>>>We have several SET RELATION in our code. Then they move the record pointer to establish the relation in the child table. The code does not work when the table is EOF() but !EOF(). This seems like an easy one but it is hurting my brain.
>>>>
>>
IF .NOT. EOF()
>> SKIP
>> SKIP -1
>>ELSE
>> IF !BOF()
>> SKIP -1
>> SKIP
>> ENDIF
>>ENDIF
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst