Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
NULLs on the backend numeric field
Message
De
03/03/1999 19:25:33
 
 
À
02/03/1999 17:37:54
Bob Lucas
The WordWare Agency
Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00193352
Message ID:
00193860
Vues:
20
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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform