Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
My trigger has gone mad
I am creating my first project, in the hope of impressing a potential employer. Not easy as I have never used this language before!!
I am trying to set a trigger so that numbers less than 0 and greater than 100 cannot be entered in an id# (called cidnum)The expression I used was ((cidnum<0) .OR. (cidnum =>100))vfp accepted the expression, but when I was trying to enter data, it wouldn'nt accept any number. Do I have to assign a value to this field first?????????
Any advice greatly appreciated.
Colette
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