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