Information générale
Catégorie:
Codage, syntaxe et commandes
>I would like to use my own message when a user enters a duplicated unique id instead of FoxPro's "Uniqueness of index is violated" message. How do I do that?
If you're actually talking about the Primary key, do not allow users to enter them. They should be generated by the app, and should have no real-world meaning. They should be nothing more than internal identifiers.
Anyway, are you using buffered cursors or are you using the tables directly? If you're using buffered cursors, before doing the save, you can use an SQL statement to select for fieldname = entered value. If you get _tally > 0, then it's not unique, and you can message the user.
Alan
Précédent
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