Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Handling Null values on form and saving it in SQL server
Message
De
01/07/2014 03:55:51
Upendra Nayak
Cadsys Technologies
Mumbai, Inde
 
 
À
01/07/2014 03:37:19
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01602939
Message ID:
01602942
Vues:
71
Hi Dragan

The question is for each field the valid values
can be actual value (know to the user) or null (for value not known to the user) in the sql field.

e.g. if we have a field called salary then the valid
values can be Zero to some figure. But if the user
does not have the information for that field then
the value should be null.

Please note that in above example even Zero
is a valid value. Hence Zero and null value
have there own meaning.

Zero salary can be valid for a director of a company.
Null value can be valid for a person for whom we don't have any information.

Question here is how should be our data entry screen.


Regards
Upendra Nayak
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform