Vin:

After much searching for an alternate solution, I did wind up using the workaround you suggested below, so I wanted to write a quick thank-you for the suggestion.

For the record, I did find a couple people who have encountered this problem in the past, and neither of them had found a better solution (one re-architected his system to avoid the RollbackTrans() call, the other used a similar workaround).

Anyway, thanks again.

. . . . . . . -- Eric

>Hey Eric. Now I follow you better.
>
>I usually start the trans before #1 (in your example). That you will roll back to an empty record, but in that case I just fill in again based on the prior entries. My favorite method for doing this (because it's so quick) is to call GetString() before the attempt to save; then, on a failure, throw this delimited string into an array; then, scan the array and fill in each field of the RS.
>
>Just remember to delimit the fields using a string that you would not find in valid data -- I frequently use "%_*_%" ....
>
>There may be other approaches, but this is what I have done in the past.