>Dear Sir,
>
>I have these codes
>
>
>CREATE CURSOR junk (sno n(3),amount n(6))
>INSERT INTO junk VALUES (1,500)
>INSERT INTO junk VALUES (2,600)
>INSERT INTO junk VALUES (3,700)
>INSERT INTO junk VALUES (5,800)
>INSERT INTO junk VALUES (6,900)
>INSERT INTO junk VALUES (7,1000)
>INSERT INTO junk VALUES (8,1100)
>INSERT INTO junk VALUES (10,1200)
>INSERT INTO junk VALUES (11,1300)
>
>
>
>
>
>
>
>
>In sequence, if found any missing sno then replace the maximum number of sno with missing sno.
>
>In the above example sno=4 is missing and maximum sno is 11
>so sno 11 is being replaced with sno 4 and so on.
>
Why would you want to do this? It's likely to break other data. That is, if you have any tables that relate to this one based on the sno, you'll break those connections.
Tamar