Consider the use of Win32-GUI-Grid as well.
It is an optional choice as it may require large portions of recoding, but may streamline the data-access logic.
I use it in conjunction with SQLite in an application I produce with next to nil delay.
On Behalf Of Eric Hansen
Sent: Thursday, February 02, 2006 10:32 AM
Subject: [perl-win32-gui-users] RE: ListView Columns - Text Limit is 1023 Bytes
The options I have thought of to correct my application are:
1) load the database data memo fields to an associative array at the same time I load the data to the ListView.
And then populate the maintenance screen’s multiline textfields (to hold the memo fields) in the ListView
2) In the ListView ItemClick event, do a database lookup to fetch the memo fields at that time instead of
Holding all record memo fields in an associative array loaded when the ListView is loaded.
I chose number 2. The slight drawback to this method is the slight delay when arrowing or scrolling up/down
Within the ListView since the ItemClick event has to do a database lookup. The slight delay really is not
Noticeable but could potentially be if network traffic or database traffic is high.