>Hi,
>
>After using an Insert SQL to append a record, is it possible to cancel this record (not delete, because of using a primary key), without resorting to the BEGIN TRANSACTION and ROLLBACK.
>?
>
>Thanks, J
I think there is not. Why don't you want to use transactions?
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)