Hi Jason,

I won't be able to provide that before Monday though the only thing missing would be to make a small demo db. Will try to do that on Monday.

Until then please see my last post about how "AutoFetchAll" being set to false causes this issue for me. My interpretation is that in this case the buffers are cleared and refreshed according to the new ordering -> the selected record is no longer in the buffer and thus cannot be selected again.

As I said I don't even know if this is an error.. I mean would not clearing the buffers lead to inconsistent data?

Example 1 - I have this table with ID and TEXT and sorted by ID ascending.

1 Hello

2 Jason, <- SELECTED

3 how

4 are you?

Now I click on the ID row again to change the sorting leading to..
1074 good. <- SELECTED
1073 was
1072 holiday
1071 My

But what would be the expected result if I want the record with ID=2 to be selected? Wouldn't the IBOs have to fetch all records between 2 and 1074 first?

Again, I'm not really sure but setting AutoFetchAll=TRUE was the solution for now. It would be even better to have a solution that produces less network traffic though.

Regards,
Thomas


Von: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Im Auftrag von IBO Support List
Gesendet: Fr, 21. Juni 2013 16:30
An: IBObjects@yahoogroups.com
Betreff: RE: [IBO] AW: Current record lost on sorting by a column in TIB_Grid



Will you please send me a simple sample app with a database where this is
confirmed to be reproducable?
Send it directly to my email address please.

Thanks,
Jason
www.ibobjects.com

-----Original Message-----
From: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com> [mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>] On Behalf
Of Thomas Lenders
Sent: Tuesday, June 18, 2013 2:31 AM
To: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>
Subject: [IBO] AW: Current record lost on sorting by a column in TIB_Grid

Well,

the RefreshAction is set to "KeepDataPosOrRowNum" .. which setting is
actually the correct one if I want to keep the current record selected after
ordering? I think there must be another problem too because at this point I
actually tried every one of these setting multiple times. ;)

I can reproduce the problem in a minimal application with one of
TIB_Connection, TIB_Query, TIB_DataSource and TIB_Grid. Connect them all and
and enter a simple SQL, e.g. select a few fields from a single table,
including the primary key. Then I enter the name (including tablename like
CUSTOMER.CUSTOMERID) of the PK into the "KeyLinks" property and disable
"KeyLinksAutoDefine". Then I go to Ordering and add all fields there using
the wizard.

All other settings have their default values.

When I run the application and click on the header of any column, the
selected record changes.

Regards,
Thomas

Von: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com> [mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>] Im Auftrag
von Svein Erling Tysvær
Gesendet: Di, 18. Juni 2013 08:32
An: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com>
Betreff: [IBO] RE: Current record lost on sorting by a column in TIB_Grid

Check your KeyLinks and RefreshAction, if KeyLinks isn't set (or incorrectly
set), then IBO doesn't know how to distinguish the rows from each other and
cannot relocate, RefreshAction you can set to e.g. keep the data position or
the row number (though that probably also requires KeyLinks to be correctly
set).

HTH,
Set

-----Original Message-----
From: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com><mailto:IBObjects%40yahoogroups.com>
[mailto:IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com><mailto:IBObjects%40yahoogroups.com>] On
Behalf Of Thomas Lenders
Sent: 17. juni 2013 18:03
To: IBObjects@yahoogroups.com<mailto:IBObjects%40yahoogroups.com><mailto:IBObjects%40yahoogroups.com>
Subject: [IBO] Current record lost on sorting by a column in TIB_Grid

Hello group,

Something I did in an application using IBO 4.9.14 Build 55 caused a strange
"feature", which is that when clicking on a column header to sort by that
col, the current row changes.
Or, it could be something that changed between IBO version as switched to
the version above after receiving a patch by Jason (it was easier to
implement it in a more current version).

Anyone has an idea on the top of their head what could cause this behaviour
?

Regards,
Thomas

[Non-text portions of this message have been removed]

------------------------------------

__________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
__________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links



[Non-text portions of this message have been removed]