Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to make an index
Message
From
25/08/2008 17:40:53
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01341632
Message ID:
01341648
Views:
12
Hi,


Those brackets! of course you are correct. Please note it is 23:39 in Amsterdam. Anyhow your solution:

INDEX ON IIF(empty(Field2), Field1,Field2) + IIF(EMPTY(field2),FIELD2,DTOS(CTOD(field3))) TAG mytag
results in:
abcd " " number1
efgh abcd 31/03/2008
fghi abcd 01/03/2008
hiij bcde 18/05/2008
ghij bcde 11/05/2008
bcde " " number2

so need a little bit fineturnig 2morrow 1stthing!

Thanks sofar,
Bye,
Koen
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform