>hi,
>Actually the whole version is this way
>
>select bhav_data
>index on timestamp tag idxtime
>set order to idxtime
>
>create cursor test(t1 c(20),date d)
>
>select bhav_data
>scan
> m.timestamp = bhav_data.timestamp
> m.ld = convert_date(m.timestamp)
> insert into test(t1,date) values(m.timestamp,m.ld)
>endscan
>
>select test
>index on timestamp tag t1
>
>select bhav_data
>delete tag idxtime
>replace date with test.date for seek(timestamp,'test','t1')
>
>I tried using Sql here but was very slow in vfp6 and ideas how to speed this up ?
>
>suhashegde

select bhav_data

index on timestamp tag idxtime

SCAN
	STORE timestamp	  		TO timestamp
	STORE convert_date(timestamp)	TO dDate
	replace WHILE timestamp=m.timestamp date WITH m.dDate
	SKIP -1
ENDSCAN	

delete tag idxtime	&& why ? INDEX BLOAT : is bhav_data a table or a cursor
                        && USE A IDX INDEX