view release on metacpan or  search on metacpan

lib/Class/DBI/MSAccess.pm  view on Meta::CPAN

 
This documentation refers to Class::DBI::MSAccess version 0.01
 
=head1 SYNOPSIS
 
    package Film;
    use base 'Class::DBI::MSAccess';
    Film->connection('dbi:odbc:dbname', 'user', 'password');
    Film->table("film");
    ...

=head1 DESCRIPTION

This is a simple subclass of Class::DBI which makes Class::DBI work correctly
with Microsoft Access databases.  I've only tested this module when connecting
to the database with DBD::ODBC.  This module requires Microsoft Access 2000 or
newer (so that C<SELECT @@IDENTITY> is available).

The changes to Class::DBI are as follows:

=over 4

=item *

Use C<SELECT @@IDENTITY> to get the value of the AutoNumber primary key column
after inserting a new row.

=item *

If no value is provided for the primary key column when creating a new row,
this module removes the primary key column's name from the C<INSERT INTO> SQL
and tweaks the list of placeholders appropriately.  This causes Access to
autogenerate the new primary key value.

=back
 
=head1 CONFIGURATION AND ENVIRONMENT
 
If you connect to the Access database with ODBC, you'll need to establish the
correct ODBC settings.  Other than that, Class::DBI::MSAccess uses no
configuration files or environment variables.
 
=head1 DEPENDENCIES
 
=over 2

=item *

Class::DBI

=item *

Microsoft Access 2000 or newer

=back
 
=head1 INCOMPATIBILITIES
 
None known
 
=head1 BUGS AND LIMITATIONS

I've only tried this module with DBD::ODBC as the connection method.  If it
does or doesn't work with other connection methods, please let me know.

Please report any bugs or feature requests to
C<bug-class-dbi-msaccess at rt.cpan.org>, or through the web interface at
L<http://rt.cpan.org/NoAuth/ReportBug.html?Queue=Class-DBI-MSAccess>.
I will be notified, and then you'll automatically be notified of progress on
your bug as I make changes.

=head1 SUPPORT

You can find documentation for this module with the perldoc command.

    perldoc Class::DBI::MSAccess

You can also look for information at:

=over 4

=item * AnnoCPAN: Annotated CPAN documentation

L<http://annocpan.org/dist/Class-DBI-MSAccess>

=item * CPAN Ratings

L<http://cpanratings.perl.org/d/Class-DBI-MSAccess>

=item * RT: CPAN's request tracker

L<http://rt.cpan.org/NoAuth/Bugs.html?Dist=Class-DBI-MSAccess>

=item * Search CPAN

L<http://search.cpan.org/dist/Class-DBI-MSAccess>

=back

=head1 ACKNOWLEDGEMENTS

Ricardo Signes for writing L<Class::DBI::MSSQL>

=head1 AUTHOR

Michael Hendricks  <michael@palmcluster.org>

=head1 LICENSE AND COPYRIGHT
 
Copyright (c) 2005 Michael Hendricks (<michael@palmcluster.org>). All rights
reserved.

This program is free software; you can redistribute it and/or modify it
under the same terms as Perl itself.