>Hi toall,
>
>i have a table1 with an index 'item', my problem is how seek all items starting in 4th position to the 8th positon without changing my index?
>e.g
>abc14421xyz01
>i need to seek all 1442 using seek statement and not select statement.
>please help.
>tia
>Ryan.
Without changing the index, and without using SELECT - SQL, you can use LOCATE FOR (condition) and CONTINUE. This might be Rushmore-optimized if you have a correct index, however, changing the index order temporarily will be much faster. (That is, you can change the index temporarily to process your records, and then change it back again.)
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)