I'm just starting on an app that will need to do the same thing. Is there a generic table-aware wxPyGridTableBase that you used that you are willing to make public?
How did you link it to the database tables?
It would save me a lot of hard work (and there are plenty of other areas in this app that need the hard work).
Chris.
···
----- Original Message -----
From: Frank Millman
To: wxPython-users@lists.wxwindows.org
Sent: Tuesday, April 01, 2003 4:53 AM
Subject: Re: [wxPython-users] Help wth wxPyGridTableBase
----- Original Message -----
From: "Mike C. Fletcher" <mcfletch@rogers.com>
To: <wxPython-users@lists.wxwindows.org>
Sent: Sunday, March 30, 2003 6:08 PM
Subject: Re: [wxPython-users] Help wth wxPyGridTableBase
See section:
1.4.1 Cursor Manipulation
from http://wiki.wxpython.org/index.cgi/wxGrid .Particularly:
SetGridCursor, and MakeCellVisibleHTH,
Mike
Many thanks to Mike and to Chuck for the replies - SetGridCursor was the
answer. According to the docs, MakeCellVisible is called automatically by
SetGridCursor, so I left it out and it works fine without it.
I should have found it myself, but I was looking in the wxPyGridTableBase
class for a method, forgetting that all the methods in wxGrid are
available - twit.
The results are spectacular. I can scroll through a table of 20 000 rows,
and jump to any row I want to based on a search string, at blazing speed,
using both PostgreSQL and SQL Server. If I push it to 50 000 rows, searching
through the cursor slows down a bit, but in practice no-one will scroll
through such a big table without applying some filtering first, so I do not
think it will be a problem.
Thanks again, guys.
Frank Millman
---------------------------------------------------------------------
To unsubscribe, e-mail: wxPython-users-unsubscribe@lists.wxwindows.org
For additional commands, e-mail: wxPython-users-help@lists.wxwindows.org