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.