Information générale
Catégorie:
Gestionnaire d'écran & Écrans
>Hi all,
> I am working on a parent-child form(built from wizard). On parent part, I have a field called SERIAL NO. This SERIAL NO. must NOT be duplicated. But when I add new record(for parent part), it automatically added as default. I used LOOKUP command to compare the field against the table. Even it found the matching record and give error message but still added new record.
>
> What is the best way to handle duplicate error checking? Please help me if you have experience on this.
>
> Thank you in advance.
> Thanya.
There are many ways to handle this. You could set a unique index on the field and handle the error, or you could build a routine to query the value before the save is attempted. BTW, what do you mean you built the form from the wizard?
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