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:
00988032
Views:
39
You can press CTRL+0 to enter null into the textbox. OR, before saving the data, replace empty/zero values with null.

>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
- Jayesh
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform