select distinct custid from mytable into mycursor

select mycursor
scan
  insert into mytable (custid) values (mycursor.custid)
  insert into mytable (custid) values (mycursor.custid)
endscan


Einar



endscan
>I have a database (regular table) that has records in it sorted by a field called "customerid".  The "customerid" field identifies the customer ID number of individual records.  There are multiple records with the same customer ID number.  I want insert two empty/blank records after each group of records with the same customer ID number.
>
>What is the code to do that?

Semper ubi sub ubi.