On Fri, 2007-12-07 at 11:19 +0900, 田口 浩 wrote:
Hi
my $dbh = DBI-connect(dbi:ODBC:test, , ,
{RaiseError = 1, AutoCommit = 0, LongReadLen = 409600})
or die $DBI::errstr;
Anyone will teach me how to get all names of tables
(in test.mdb)?
$sth = $dbh - table_info(undef, undef, '%',
Thanks, table_info is ok.
I did my @tables = $dbh-tables();,
it's a simple way but it has like;
`C:\temp\test`.`MSysAccessObjects`
Answer was not good.
I wonder if we had more smart way...
$sth = $dbh - table_info(undef, undef, '%', 'TABLE');
while ($data = $sth - fetchrow_hashref() )
{
Hi. Long time to see you :-).
- Original Message -
Subject: Getting all names in mdb
Date: Fri, 7 Dec 2007 11:19:05 +0900
From: 田口 浩 [EMAIL PROTECTED]
To: dbi-users@perl.org
Hello,
I'm using .mdb file with DBI/DBD::ODBC.
my $dbh = DBI-connect(dbi:ODBC:test, , ,
{RaiseError = 1,
Hiroshi,
What names are you looking for? Column names?
Peter
-Original Message-
From: 田口 浩 [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 7:19 PM
To: dbi-users@perl.org
Subject: Getting all names in mdb
Hello,
I'm using .mdb file with DBI/DBD::ODBC.
my $dbh =
Did you try $dbh-table_info()?
(http://search.cpan.org/~timb/DBI-1.601/DBI.pm#table_info)
If yes, what was the problem?
Alexander
On 07.12.2007 03:19, 田口 浩 wrote:
Hello,
I'm using .mdb file with DBI/DBD::ODBC.
my $dbh = DBI-connect(dbi:ODBC:test, , ,
{RaiseError = 1, AutoCommit = 0,