Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NULLs on the backend numeric field
Message
From
03/03/1999 19:25:33
 
 
To
02/03/1999 17:37:54
Bob Lucas
The WordWare Agency
Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00193352
Message ID:
00193860
Views:
19
I tried the CTRL-O and it didn't work. Does anyone have any other ideas? For some reason MS Access does it automatically whereas VFP can't seem to put a null into a field on a backend.

>>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
>
>
>Type CTRL-0 in the field. That should change the value to a NULL (CTRL-ZERO)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform