General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Have to remember that one!
Jay
>Edgar
>Good challenge for us!
>here is a programatic solution for you
>
>use ster excl
>index on isblank(eclrhse) tag eclrhse &&this puts the trues between the falses and the 'blanks'
>brow && take a look and see for yourself
>go top
>copy to false.dbf while eclrhse =.F. && copy off the falses leaving us at the first true
>copy to true.dbf while eclrhse =.T. && copy off the true leaving us at the first blank
>copy to blank.dbf while eclrhse =.F. && copy off the blanks
>
>
>this will let you manipulate them separately
>whew!
>Alek
>
>>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