>Dear Experts
>
>I want to fill table with blank records, with 10 records division, such as
>
>If Table has 0 records then 10 blank recods should automatically appended
>If Table has 6 records then 4 blank recods should automatically appended
>If Table has 12 records then 8 blank recods should automatically appended
>If Table has 37 records then 3 blank recods should automatically appended
>And so on…….
>
>Please help
PRIVATE j
FOR j=RECCOUNT()%10 to 9
APPEND BLANK
NEXT
RELEASE j
or
Attention, this doesn't apply the cursor DEFAULT expressions ( a bug for me )
LOCAL ARRAY DUMMY[10-RECCOUNT()%10,1]
APPEND FROM ARRAY DUMMY FIELDS EXCEPT '*'
RELEASE DUMMY