> what for?
>
> Violating a constraint like an unique index is happening when you post
> the record - you don't have to commit or rollback the transation.
>
> Just cancel your query if you don't wnat to stay in insert mode.
>
> When the user finished the inserts then do a commit to save all
> (correct) numbers.
> All barcodes that weren't accepted are not saved anyway..
>
> Luc.

Luc,
I don't want cancel because I will loose other fields entered before an
attempt to post. And I want to be able to tell the user why I'm rejecting
the record, but to give them another chance to correct their mistake.
Alan