>iif(mod(recno()/2)=0,rgb(),rgb()) this command is used to change the dynamicbackcolor of grid. but it doesn't work well on indexed vues or tables. how to correct it ?
Depends. Is it possible to use a cursor? E.g.:
select * from thetable order by 1,2,3 into c_thecursor nofilter
The record numbers of that cursor will be fine.
Here's another trick (from the head). Assume thetable has a field named ID.
select from thetable id as col_id, 00000000 as col_color into cursor c_color nofilter
replace all col_color with iif(mod(recno(),2)=0,rgb(0,0,255),rgb(255,255,0))
index on col_id tag primary
select thetable
set relation to id into c_color
Then use c_color.col_color in the dynamicbackcolor() of the grid.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.