>select bhav_data >local aa(1) >afields(aa) >create cursor syBhav from array aa >alter table alias() add column nOpen N(12,2) >alter table alias() add column nHigh N(12,2) >alter table alias() add column nLow N(12,2) >*etc >. >. > >** then indexes you need for post processing >INDEX ON DTOS(DATE)+SYMBOL TAG PK >index on symbol+dtos(date) tag pk1 && Not present in the link below >. >. >somesymbol=YourForm.sometextbox.value >select bhav_data >seek somesymbol >scan while bhav_data.symbol= somesymbol > scatter memvar > m.nOpen = mton(open) > m.nHigh = mton(high) > m.nLow = mton(low) > . > . > insert into syBhav from memvar > > >endscan > >select syBhav >browse normal > >*then you do something with that result set. > >>