Hi!
I have a table called ORDERS DETAIL, with a field I have named DISCOUNT.
I would like to set up a validation rule that only allows a number between 0 and 1, but each time I try I get an incorrect syntax error. I am building my first application if FoxPro and have not used the expression builder before and do not know how to create the expression properly. I would appreciate any help with this expression.
Also, what data type would you recommend I use? I want the data to be a percentage (hence, between 0 and 1). How do I make the format for this field a percentage? I can do this very easily in Access, but I refuse to use Access anymore. I am dedicated to learning FoxPro!!!!!!!
Thanks in advance for your help.
Jason
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