DO WHILE Reccount("Table1") < 10
  INSERT INTO table1 VALUES(val1,val2,val3,etc.)
ENDDO

>Dear Sir,
>
>Field1 of Table1 is numeric type containting 4 records. I want to fill next 6 records with digit 1 for example
>
>5,2,4,6,1,1,1,1,1,1
>
>Sometimes table has 6 records then last 4 records must append with digit 1
>
>When command run it will count records in table and append digit 1 until reccount() is equal to 10
>
>Please help