I am using an append blank command followed by replace ident with oSession.get_unique_id. It works fine most of the time but if there is a failure somewhere, I have a record with 0 in the ident field and then of course the next user trying to add fails with a uniqueness of index blabla error.

I wonder: If I use an INSERT SQL command with ident=oSession.get_unique_id(), will it create the record with the proper ident without going through a 0?

Second question: After an INSERT SQL, will the current record always be the good one ? Can I perform some replace on it if need be just after ?

Thanks
Eric.