Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
If delete data, how to set table value to .NULL.
Message
De
17/02/2005 14:06:25
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows NT
Network:
Windows NT
Database:
Visual FoxPro
Divers
Thread ID:
00988027
Message ID:
00988035
Vues:
39
>I have some textboxes that display values from a table. The type of these values is double. The default value is .NULL.
>
>As expected, when I create a blank record, these values are initialized in the table to .NULL.
>
>When the user enters a number into the textboxes, the table values get updated appropriately, i.e. the table value becomes that number.
>
>However, if a user now selects that textbox and deletes its contents, the table value does not revert to .NULL., but instead becomes the value 0.0. This is not correct.
>
>What is the best way to have the table value go back to .NULL. when the user deletes the value from a textbox bound to that table field?
>
>Thanks,
>Jim
CTRL+0 put a NULL into the textbox
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform