and I run it and it send a very long error message :use DBI; my $dbhX = DBI->connect("DBI:XBase:/proyecto"); my $dbhA = DBI->connect('dbi:AnyData(RaiseError=>1):'); $dbhA->ad_catalog('etstx','CSV','etstx.csv'); my $sth = $dbhX->prepare("SELECT * FROM reg501"); $sth->execute(); $dbhA->do("CREATE TABLE etstx AS SELECT * FROM ?",{}, $sth);
SQL ERROR: Bad table or column name '?' has chars not alphanumeric or +underscore! DBD::AnyData::db do failed: SQL ERROR: Bad table or column name '?' ha +s chars not alphanumeric or underscore! Can't call method "execute" on an undefined value at C:/Perl/site/lib/ +SQL/Statement.pm line 254. [for Statement "SELECT * FROM ?"] at testdbf.pl line 8. DBD::AnyData::db do failed: SQL ERROR: Bad table or column name '?' ha +s chars not alphanumeric or underscore! Can't call method "execute" on an undefined value at C:/Perl/site/lib/ +SQL/Statement.pm line 254. [for Statement "SELECT * FROM ?"] at testdbf.pl line 8.
In reply to Re^8: One Question about DBF
by padawan_linuxero
in thread One Question about DBF
by padawan_linuxero
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |