>I want to index a file on descending order of fields 1 and 2 but within that on ascending oder of fields 3 - how can I do this?
>
>I have tried this but it doesn't work
>
>index on dupkey+codex DESCENDING, COPYNO ASCENDING TAG docky

	create cursor xx ;
	(	dupkey		c(4), ;
		codex 		c(2), ;
		copyno		c(32) ;
	)
	
	insert into xx values ('abcd', '12', 'Copy No 421')
	insert into xx values ('bbcd', '12', 'Copy No 421')
	insert into xx values ('cbcd', '12', 'Copy No 421')
	insert into xx values ('cbcd', '12', 'Copy No 422')
	
	index on bitnot(cast(dupkey+codex as blob)) + copyno tag xx