Information générale
Catégorie:
Codage, syntaxe et commandes
>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.
One way to get around this is to put the call to your unique id routine in the default setting for the field. You can then issue an APPEND BLANK with no problems.
>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?
INSERT SQL is another alternative. Works well.
>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 ?
Not sure what you mean.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement