General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Exactly where I'm heading - but this is a legacy table - I needed the three state recognition in the end...
>
>>>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?
>>
>>It may be apparent that using your own data type represented by a character like -- "Y", "N", or "U" would give you the discrimination that you need.
>>
>> Jay
Can you add a logical field to the table to indicate whether or not the data has been entered for this field?
Jay
Previous
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