>Pete,
>Wouldn't actually only first time creation of an index take time. Create and index :
>index on right(myDateStr,4)+left(myDateStr,4) tag myDateSort
>
>*Scan
>set key to range dtos(DateStart), dtos(dateEnd)
>scan
>...
>endscan
>
>Cetin
Hi Cetin,
Very interesting idea. I've never tried the 'set key to range' function before. I'll certainly give it a try.
I'm not sure what you mean by "only first time creation of an index take time." I append the 5.5Meg record table once a week with 40Kilo records. Table then auto-re-indexes the 6 indexes. Takes over a half hour. I should mention this is over Novell 4.1 LAN. Difference is remarkable if table is local; only takes a couple of seconds.
Pete
NB to the purists among you who would criticize my use of 'indexes' instead of 'indices', I point out that 'indexes' is more in the vernacular, understandable and certainly a lot easier to pronounce. I also point out the following:
Plural of mouse: mice
Plural of house: hice?
BTW, FWIW, what do you call multiples of that object beneath your hand that you move the screen cursor with? I use a trackball, nnyyaaah! :-)
Peter Adams
FoxPro Programmer
Compu-Mail
Heisenberg was probably right...