Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
If delete data, how to set table value to .NULL.
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows NT
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00988027
Message ID:
00988040
Views:
57
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
Previous
Reply
Map
View

Click here to load this message in the networking platform