Dear Experts
I have following codes
CREATE CURSOR sales(sno n(4),code1 c(4),rate n(7,2))
INSERT INTO sales values(1828,"1401",1548.65)
INSERT INTO sales values(1828,"1402",1485.15)
INSERT INTO sales values(1825,"1402",1300.05)
INSERT INTO sales values(1825,"1402",1205.15)
INSERT INTO sales values(1825,"1403",1780.35)
INSERT INTO sales values(1825,"1403",1905.15)
INSERT INTO sales values(1828,"1402",1800.05)
INSERT INTO sales values(1828,"1402",1800.05)
sno---- code1---- rate
1828---- 1401---- 1548.65
1828---- 1402---- 1485.15
1825---- 1402---- 1300.05
1825---- 1402---- 1205.15
1825---- 1403---- 1780.35
1825---- 1403---- 1905.15
1828---- 1402---- 1800.05
1828---- 1402---- 1800.05
sno---- code1---- rate
1828---- 1401---- 1548.65
1828---- 1402---- 1485.15
1825---- 1402---- 1300.05
1825---- 1402---- 1205.15 && I want to append two blank records after this record then copy above two records in blank rows
1825---- 1403---- 1780.35
1825---- 1403---- 1905.15
1828---- 1402---- 1800.05
1828---- 1402---- 1800.05
I need dbf as following final position
sno---- code1---- rate
1828---- 1401---- 1548.65
1828---- 1402---- 1485.15
1825---- 1402---- 1300.05
1825---- 1402---- 1205.15
1825---- 1402---- 1300.05
1825---- 1402---- 1205.15
1825---- 1403---- 1780.35
1825---- 1403---- 1905.15
1828---- 1402---- 1800.05
1828---- 1402---- 1800.05
See attachment please for more detail