Seek or scope for not empty dates

[Enrico Maria Giordano]

Dear friends, how can I seek or scope for not empty dates other than using an index with for clause !Empty( FIELD -> date )?

Thank you in advance for any ideas.

EMG

[ADutheil]

If you have an index based on filed->DATE you might soft seek ou bottom scope to the first day of the epoch your are set.

[James Bott]

Can you give us some examples where it is a problem?

[nageswaragunupudi]

ORDSCOPE( 0, CTOD( "" ) + 1 )
DBSEEK( CTOD("") + 1, .T. ) // softseek

[Enrico Maria Giordano]

Thank you, my friends.

EMG

[James Bott]

Nages,

Sharp thinking! I like it.

James

[Enrico Maria Giordano]

One more puzzle.

What about to seek or to scope for a logical value + a string? Currently I'm using this index key:

Code: Select all  Expand view

INDEX ON IF( FIELD -> priorita, " ", "*" ) + UPPER( FIELD -> societa ) TO SOCIETA2

SEEK " "
SEEK "*"

SET SCOPE TO " "
SET SCOPE TO "*"

But I'd like to use a simpler key, removing IF() if possible. Any ideas?

EMG

[ADutheil]

You could create 2 distincs tags with FOR clause, one FOR priorita and the other FOR !priorita. Otherwise I can´t see how to get rid of the IF.

[Enrico Maria Giordano]

You could create 2 distincs tags with FOR clause, one FOR priorita and the other FOR !priorita. Otherwise I can´t see how to get rid of the IF.

Thank you.

EMG

[Enrico Maria Giordano]

You could create 2 distincs tags with FOR clause, one FOR priorita and the other FOR !priorita. Otherwise I can´t see how to get rid of the IF.

I just realized that I need that index for records sort, not for seek or scope. So your idea doesn't solve my problem, sorry.

EMG