Re: How to keep the sequence?

Kim Ng (kimmng_at_pebbles.uswnvg.com) wrote:
: I don't know anything about SQLWIN. So, this is just a general comment.
 

: If the input sequence is important, why don't you keep track of it. For
: example, you can assign a sequence number to each row.
 

: Good luck.

Thanks for responding. I think I should clarify my question again. Yes, sequence number will only help if i key in the data sequentially. My problem is that I may insert data in between a certain sequential number.

For example, i have row 1, 2, 3, 4, 5, 6....etc I would like to insert a new row in between 4 and 5. Can I use trigger for this?

Can someone tell me what is the MAX value of the sequential number? What if the running number runs out one fine day??

Thanks. Received on Wed Jan 11 1995 - 12:42:33 CET