>1.)After Append Blank fires....the Scan does not go to the next record...
>2.) If I comment out APPEND BLANK..then if will go...
>
>What can I do. I tried using Insert Into..and still same issue
>3.)z2 is a Cursor that is ReadWrite
>***********************************************************************************************
>SELECT z2
>
>SCAN
>
> SELECT zafl
> SEEK z2.zbpile + str(z2.zbshee,7)+ z2.zbmark ORDER ZBZONE
>
> IF FOUND()
>
> SELECT z2
> APPEND BLANK
> replace z2.zone WITH '99'
>
> ENDIF
>
>
>ENDSCAN
>***********************************************************************************************
Mike -
When you do the APPEND, then file pointer will go to the bottom of the table. After doing the processing (APPEND, REPLACE) the SCAN think it is finished because it is at the end.
Try this instead:
SELECT zbpile, zbshee,zbmark FROM Z2 INTO CURSOR csrZ2
select csrZ2
SCAN
SELECT zafl
SEEK csrz2.zbpile + str(csrz2.zbshee,7)+ csrz2.zbmark ORDER ZBZONE
IF FOUND()
SELECT z2
APPEND BLANK
ENDIF
ENDSCAN
cmt
Carsten M. Thode