Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
It isn't logical
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00572155
Message ID:
00572209
Views:
37
Ok I was close,
It will put the blanks at the end the trues ans falses with be in no particular order
well you can still use it for that any way.
Alek

>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
Alek Massey
- The only stupid question is one left unasked -
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform