I have a fix for this in the next sub-release.

Let me know if you need and immediate patch file.

Kind regards,
Jason Wharton
www.ibobjects.com

----- Original Message -----
From: <IBOForum@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, May 15, 2003 6:17 AM
Subject: [IBO] Locate


> Hi, please help me, i'm totally helpless
>
> short example:
>
> 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
>
> if AutoFatchAll property is True everything's fine,but i can't use this
way
> because of size of table
>
> thanks
> peter