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
Board index FiveWin for Harbour/xHarbour Seek or scope for not empty dates
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.
Regards,
André Dutheil
FWH 13.04 + HB 3.2 + MSVS 10
André Dutheil
FWH 13.04 + HB 3.2 + MSVS 10
Can you give us some examples where it is a problem?
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
ORDSCOPE( 0, CTOD( "" ) + 1 )
DBSEEK( CTOD("") + 1, .T. ) // softseek
Regards
G. N. Rao.
Hyderabad, India
G. N. Rao.
Hyderabad, India
Thank you, my friends. 
EMG
Nages,
Sharp thinking! I like it.
James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
One more puzzle. 
What about to seek or to scope for a logical value + a string? Currently I'm using this index key:
But I'd like to use a simpler key, removing IF() if possible. Any ideas?
EMG
What about to seek or to scope for a logical value + a string? Currently I'm using this index key:
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
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.
Regards,
André Dutheil
FWH 13.04 + HB 3.2 + MSVS 10
André Dutheil
FWH 13.04 + HB 3.2 + MSVS 10
ADutheil wrote: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
ADutheil wrote: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