Michael, I am having some trouble running your appl under MS-SQL 7.0. I Have
128MEG RAM on a 333MHZ PC and I am getting memory errors when I expand the
tree nodes for each table. I am not sure what the trouble could be unless it
is something to do with a data type in my database (NorthWind sample
database that installs with SQL 7.0)? I can run TreeView samples that ship
with Win32::GUI and don't get memory errors. I do not get anything diplaying
in the ListView at all.
I do like how you broke the screen into "frames" to show database properties
in one frame(TreeView), the sql command in one frame(Rich Edit of
Textfield), and the sql result set in another frame(ListView). How far do
you plan to take this?
My DBSCROLLGRID.pl I posted to the forum was headed in this direction. It
lets you key an sql on the fly also. It uses a ODBC scroll cursor to allow
the user to navigate bydirectionally in the result set. It only loads 100
rows at a time to the ListView. It works for SQL 7.0 but not MS ACCESS since
it requires the Driver to return a ROWNUMBER for each item in the Result for
use in Absolute row positioning.
DBGrid.pl loads the whole result set to the ListView which is okay for small
tables (say...less than 20,000 rows like in a MS ACCESS table). DBGRid.pl
was headed more in the direction of an Editable Spreadsheet with the ability
to update the database and export selected rows and columns to an export
file. I need more events, methods, and properties for the ListView control
to be built before I can proceed with that. There does not appear to be a
way to get data out of a ListView at present. I really don't want to develop
it using an array to store the same data just so I can access the data for
updating and exporting.
Eric Hansen
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mike Kangas
Sent: Wednesday, October 20, 1999 9:19 AM
To: [EMAIL PROTECTED]
Subject: Re: [perl-win32-gui] PerlSQL (a dbgrid++)
Thanks for the input. I will look into this.
Thanks again.
"Philip A. Larson" wrote:
> I tried it out on my MS-SQL 7.0 and it works good. But can you add a
feature
> that would show more than just the system dsns? Also, can you add a
feature
> that would browse to file dsn's on other machines on the LAN?
>
> Thanks,
>
> Phil Larson
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mike Kangas
> Sent: Tuesday, October 19, 1999 1:06 PM
> To: Perl_GUI newsgroup
> Subject: [perl-win32-gui] PerlSQL (a dbgrid++)
>
> I have taken the dbgrid.pl idea and modified it. I don't know if this is
> the direction that Eric wanted to take this module. If this is not the
> direction we can keep them separate.
>
> O.K. That being said.....
> I have used and modified some of Eric's ODBC functions and created a new
> interface. The interface idea comes from Linux's KMySQL. I am taking
> requests, suggestions and if anoyone has the need to play and modify the
> code.... Please do so. The ability to create SQL statements has not yet
> been implemented and I am sure you will be able to break it pretty
> easily.
>
> Either way... have fun.
>
> --
> Michael Kangas
> [EMAIL PROTECTED]
--
Michael Kangas
Anlon Systems, Inc.
[EMAIL PROTECTED]
