SPUG: Re: SPUG@cpan.org and projects

[Patterson, David S (Pat)]

If nothing else, it would make a great presentation at one (or both) of our
meetings... (hint, hint, hint!)

> 	---
		"A morning without coffee is like something without
something else..."

> 	D. S. "Pat" Patterson
> 	Software Engineer
> 	AVAYA communication  
> 	6464 185th Ave NE
> 	Redmond, WA  98052-6736
> 	425-558-8672
> 	888-501-4835 Pgr
> 	davidpa at lucent.com
> 
> -----Original Message-----
> From:	wwg at tscnet.com [SMTP:wwg at tscnet.com]
> Sent:	Wednesday, July 19, 2000 9:28 AM
> To:	spug-list at pm.org
> Subject:	SPUG: Re: SPUG at cpan.org and projects
> 
> Hello, all --
> 
> I've been lurking for the better part of a year,
> although I did post one response to a Linux-related
> question a while back.  My name's Bill Graham, and I am
> currently primarily a Java developer in my day job, but
> use Perl for many things, and have personal projects
> ongoing ...
> 
> Anyway, I have a project that I'd be willing to move
> under the SPUG at cpan auspices, if anyone's interested. 
> It's a Perl/TK database browser/query tool using DBI. 
> In its current form, once you connect to the database,
> you are presented with a tree view of tables, which you
> can expand to view columns by clicking on the table.  If
> you select columns from one or more tables, you can
> click a "Generate Query" button, and a SELECT statement
> is created in the query window for all table.columns you
> highlighted (you then have to specify the join and any
> other filter criteria - possible future enhancement is
> to examine foreign keys to try to determine the most
> likely join ...).  The query can then be executed &
> results displayed, etc.  If you have multiple sql
> statements in the query window, you can highlight any
> one of them and execute only that statement.  Finally,
> I'm working on a routine to create a default data entry
> form based on specifying a table name (similar to the
> table wizard in Access, but simpler / not as slick). 
> Currently, that piece can retrieve all the column names
> and construct a form with column name labels and text
> entry fields for each.  The code to
> query/update/insert/delete/navigate in the form isn't
> there yet ...
> 
> I've used it with MySQL and Oracle8i, both on Linux.  I
> haven't worked on it much in the last couple of months
> due to job time constraints.  Anyone interested??
> 
> Best Regards,
> Bill Graham
> 360 Powered Corp.
> www.360.com
> 
> =========================================
> This mail sent through Sinclair's WebMail
>       http://mail.sinclair.net
> 
> 
>  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>      POST TO: spug-list at pm.org       PROBLEMS: owner-spug-list at pm.org
>       Subscriptions; Email to majordomo at pm.org:  ACTION  LIST  EMAIL
>   Replace ACTION by subscribe or unsubscribe, EMAIL by your Email-address
>  For full traffic, use spug-list for LIST ; otherwise use spug-list-digest
>   Seattle Perl Users Group (SPUG) Home Page: http://www.halcyon.com/spug/
> 

 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
     POST TO: spug-list at pm.org       PROBLEMS: owner-spug-list at pm.org
      Subscriptions; Email to majordomo at pm.org:  ACTION  LIST  EMAIL
  Replace ACTION by subscribe or unsubscribe, EMAIL by your Email-address
 For full traffic, use spug-list for LIST ; otherwise use spug-list-digest
  Seattle Perl Users Group (SPUG) Home Page: http://www.halcyon.com/spug/