Hello, I going to be a little long, sorry for that,
My problem : =========== I've plugged a virtual ListView( a grid) control on sqlite.
I use a cache populated from sqlite_get_table and I show data directly from the buffer into the listview.
I use OFFSET and LIMIT to get just the needed data.
When I click in a row in the table, I Highlight a (geo)graphic in another window.
When I click on a column header I use the ORDER BY clause
Everything works fine.
BUT ===
When I click on a graphic object in the other window, I would like to highlight the row in the above table.
How can I get the row number in the table without doing a sequential search (which lead to many cache invalidation, data fectching and so on).
I know how to get the ROWID, but it doesn't help if the data is sorted.
What I need is the rowid of the sorted data Is it possible ?
Thanks Noël
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
