NAME

SPOPS::DBI::Sybase -- Sybase-specific routines for the SPOPS::DBI

SYNOPSIS

 # In your configuration:

 'myspops' => {
     'isa' => [ qw/ SPOPS::DBI::Sybase SPOPS::DBI / ],

     # If you have an IDENTITY field, set syb_identity to true
     'syb_identity' => 1,
     ...
 },

DESCRIPTION

This just implements some Sybase-specific routines so we can abstract them out.

One of them optionally returns the IDENTITY value returned by the last insert. Of course, this only works if you have an IDENTITY field in your table:

 CREATE TABLE my_table (
   id  numeric( 8, 0 ) IDENTITY not null,
   ...
 )

NOTE: You also need to let this module know if you are using this IDENTITY option by setting in your class configuration the key 'syb_identity' to a true value.

METHODS

sql_quote

DBD::Sybase depends on the type of a field if you are quoting values to put into a statement, so we override the default 'sql_quote' from SPOPS::SQLInterface to ensure the type of the field is used in the DBI->quote call.

BUGS

None known.

TO DO

Nothing known.

SEE ALSO

SPOPS::Key::DBI::Identity

DBD::Sybase

DBI

COPYRIGHT

Copyright (c) 2001-2002 intes.net, inc.. All rights reserved.

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

AUTHORS

Chris Winters <chris@cwinters.com>

See the SPOPS module for the full author list.