Hello Peter,

> i have table : CREATE TABLE TABLE1 (COLUMN1 VARCHAR(10))
>
> there are some records in the table, for example :
> "a"
> "ab"
> "abc"
> ...
> "x"
> "xa"
> "xc"
> "xd"
>
>
> i fill SQL property with this statement
> 'SELECT COLUMN1 FROM TABLE1 ORDER BY COLUMN1';
>
> after executing Locate('COLUMN1','x',[lo]) method, "xb" record is
> located, not "x" that i expected in view of the fact that there is
> ORDER BY clause in the statement

What's in the LocateOptions?

> if AutoFatchAll property is True everything's fine,but i can't use
> this way because of size of table

I remember someone had the same problem a couple of months ago. He/she
too reported that the problem went away if AutoFetchAll was true. I
don't remember the outcome, but if it isn't something in your
LocateOptions, an archive search might set you on the right track!

Greetings,
Paul Vinkenoog