>hi all,
> i need to insert new record between records at mytable.
>any help
>thanks.
Use an index to control the
logical record position. The record will be appended at the end of the table, but the index will make it appear at a position which depends on the index expression.
Note: The INSERT command can be used to do what you are asking for, but: (1) This only works if the table has no indices, and (2) This is not good practice, since for a large table, the process will be very slow.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)