Sorry Fabio, you're right. I don't know what I was looking at, or what I
thought I was looking at before when I tested it.
Alan
>
>Fabio,
>
>Ok, now try the same thing with SEEK 5. And then try Seek(5). They don't operate the same way. Setting NEAR ON won't stop Seek() from going to EOF() the way it does with SEEK. Your example below only shows that Setting NEAR ON will work with Seek() under certain circumstances but not always. That means it's unreliable for any real coding.
>
>Alan
>>
>Sorry, i don't see this.
>Give me a example where this happen
>
>This go to EOF(), always.
>
>clear
>CREATE CURSOR myC ( aaa I )
>INSERT INTO myC VALUES (1)
>INSERT INTO myC VALUES (3)
>
>INDEX ON aaa TAG tag1
>
>SET NEAR OFF
>
>GO TOP
>? SEEK(5),aaa,EOF()
>GO TOP
>SEEK 5
>? AAA,EOF()
>
>SET NEAR ON
>
>GO TOP
>? SEEK(5),aaa,EOF()
>GO TOP
>SEEK 5
>? AAA,EOF()
>
>
>Fabio