Subject RE: [IBO] Looking for rationale...
Author Alan McDonald
> 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.

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.