General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Technically it's not unpopulated. A logical stores a 0 or 1 (.f. or .t.) an empty value can't exist. I've never tried it, but you may want to try to use NULL for a third value (although that doesn't help your current situation) Sorry I couldn't be more help.
Tom
>Tom,
>So there is no way to select out the unpopulated?
>
>>A logical field in FoxPro defaults to .F. even if it's not "populated".
>>
>>Tom
>>
>>>Hello UT,
>>>
>>>select * from ster where SubStr(sunum,1,1) = "E" .AND. eclrhse == .F.
>>>
>>>returns cursor containing "unknown" or "unmarked" records as well.
>>>(logical not known yet)
>>>How may I return only records containing marked-logical-False?
Previous
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