Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Logical fields
Message
From
17/04/2015 04:39:42
 
 
To
17/04/2015 04:29:00
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01618597
Message ID:
01618611
Views:
45
>>>>Hi All,
>>>>
>>>>A strange question perhaps; logical fields in a table start of as blank when browsed. But once set to .T. or .F. you cannot revert the field to a blank. Anyway to do that? Just a curiosity really.
>>>
>>>Are they actually nulls rather than "blanks"?
>>
>>One would imagine so but you cannot replace a .null. into a logical field. So ... not sure ?
>
>Sure you can put a null into a logical field as long as it is defined to accept nulls
>
>
>create cursor xxx ( xxx L null )
>insert into xxx values(null)
>
>browse
>
>
>or
>create cursor xxx ( xxx L null default null)
>append blank
>browse
>
Cool, didn't know that. Thanks!
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Reply
Map
View

Click here to load this message in the networking platform