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(); . . . __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com