Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Uniqueness of index failed with append blank...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00267107
Message ID:
00267112
Vues:
19
>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
Fil
Voir

Click here to load this message in the networking platform