NAME

Meta::Widget::Gtk::SqlList - a CList widget that displays result of an SQL query.

COPYRIGHT

Copyright (C) 2001, 2002 Mark Veltzer; All rights reserved.

LICENSE

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111, USA.

DETAILS

        MANIFEST: SqlList.pm
        PROJECT: meta
        VERSION: 0.13

SYNOPSIS

        package foo;
        use Meta::Widget::Gtk::SqlList qw();
        my($object)=Meta::Widget::Gtk::SqlList->new($def,);
        my($result)=$object->refresh();

DESCRIPTION

Create this widget, assign an SQL statement to it and forget about it. The widget will: 0. prepare the statement so issueing refreshes to it will be easier. 1. will handle the right button mouse click and will offer the user the option to refresh whenever the mouse is on top of it. 2. will parse the SQL statement given to it and will create the columns of the list accoding to the columns which are returned from the query. 3. will display hints on column names according to descriptions in the database schema. 4. if the database updates and can send signals, this widget will automatically update the information in its display.

This now uses the new SQL::Statment version by Jeff Zucker (better).

FUNCTIONS

        new_statement($$$$)
        refresh($)
        TEST($)

FUNCTION DOCUMENTATION

new_statement($$$$)

This is a constructor for the Meta::Widget::Gtk::SqlList object. This is the constructor you should use since it gets all the parameters needed for correct construction.

refresh($)

This method will rerun the quest and will refresh the display. It does so by first clearing the display, then issueing the prepared statement and then appending all results to the widget.

TEST($)

Test suite for this module.

SUPER CLASSES

Gtk::CList(3)

BUGS

None.

AUTHOR

        Name: Mark Veltzer
        Email: mailto:veltzer@cpan.org
        WWW: http://www.veltzer.org
        CPAN id: VELTZER

HISTORY

        0.00 MV advance the contacts project
        0.01 MV xml/rpc client/server
        0.02 MV perl packaging
        0.03 MV md5 project
        0.04 MV database
        0.05 MV perl module versions in files
        0.06 MV movies and small fixes
        0.07 MV thumbnail user interface
        0.08 MV more thumbnail issues
        0.09 MV website construction
        0.10 MV web site automation
        0.11 MV SEE ALSO section fix
        0.12 MV weblog issues
        0.13 MV md5 issues

SEE ALSO

Gtk(3), SQL::Statement(3), strict(3)

TODO

-add the prepare stuff.

cpanm Meta::Init

perl -MCPAN -e shell
install Meta::Init