You will find the "supported" data-types in SQL::Dialiects::CSV of the
SQL::Statement package. There in no POD, but the section [VALID DATA TYPES]
lists all possible types. DATE is unfortunately not there (DBD::CSV 0.22).

Hope that helps

Robert

--

larry s schrieb:
Does anyone know why the following fails with: "SQL ERROR: 'DATE' is not a recognized data type!" ?

I cannot seem to find valid data types.

use DBD::CSV;
use DBI;
my $table = "csvtest";
my $dbh = DBI->connect("DBI:CSV:f_dir=/home/lsturtz/perl/")
    or die "Cannot connect: " . $DBI::errstr;
my $sth = $dbh->prepare("CREATE TABLE $table (symname CHAR(10), level REAL(10,2), 
obvdate DATE )")
    or die "Cannot prepare: " . $dbh->errstr();

$sth->execute() or die "Cannot execute: " . $sth->errstr();
.
.
.



Reply via email to