Will you send me a simple sample application demonstrating this problem?

----- Original Message -----
From: <IBOForum@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, May 31, 2003 4:18 AM
Subject: [IBO] Locate vs CommitTransaction


>
> Hi,
> I have problem, plese help me.
>
> I am using TIBODatabase and TIBOQuery objects.
>
> SQL statement is simple "SELECT FIELD1 FROM TABLE1 ORDER BY FIELD1"
> FIELD1 is a PRIMARY KEY
>
>
> All TIBODatabase object's properties are default
>
> and all TIBODataset's properties are default too, but this one
> KeyLinksAutoDefine := False;
>
> I set KeyLinks property to FIELD1
>
> so, if i use this object's settings, method Locate doesn't work fine.
> It does't locate first record with respect to ORDER BY clausule.
>
> if I set KeyLinksAutoDefine := True; Locate works well,but i have
another
> problem.
> After TIBODatabase.CommitTransaction dataset won't point at same record,
> but
> moves a few records down. If all records are fetched or FetchAll property
> is True, everything works' fine.
>
>
> But this isn't solution for me.
>
>
> thanks
> Peter