Hi Eric. Thanks for the thanks! Glad I could help.


>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.