Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
If delete data, how to set table value to .NULL.
Message
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:
00988040
Vues:
53
One more idea. Trap the delete key at textbox level. If user place Delete, replace the value with NULL. I would suggest to subclass regular texbox and use it everywhere.

>Jayesh,
>
>Thanks for your quick reply to my posting. Couldn't have been more than a minute or two!
>
>I thought of the Ctrl-0 strategy, but that isn't good because it requires the user to do something unusual. "Doesn't delete mean delete??" So, I couldn't be confident that they would always do the right thing.
>
>The second strategy of just replacing zero values with .NULL before sending it to the table won't work either because 0.0 is valid data. Maybe the user really wants the value to be 0.0.
>
>I was hoping that I could end up with something quite automatic, much like it is now, i.e. bind the textbox to the field and it gets automatically updated.
>
>Any thoughts along that line?
>
>Jim
- Jayesh
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform