General information
Title:
NULLs on the backend numeric field
Visual FoxPro 5.0
On the backend, a numeric field that allows NULLS.
When I pulled up the table by a remote view (in a browse
window), the field had a value in it. I wanted to change
that value (let us say 76) to a NULL.
How do I do it?
I typed NULL.
I type .NULL.
It kept changing itself to the zero (o) which is incorrect.
I don't want a zero, I want it to be NULL.
I went to the Visual FoxPro menu item:
Table
Replace Field
With (command button)
Logical Dropdown and chose NULL.
Once again it changed itself to the zero (o) which is incorrect.
I don't want a zero, I want it to be NULL.
So how do I put a NULL in the field from VFP.
Yes, I double checked and the field on the backend
allows NULLs.
Thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only