Re^2: Generate A DDL From Access

remiah,
Grrr. I had a nice long response and lost it.

Would it be possible to share what you are using for a connection string and a complete copy/paste of what you see for table_info(), column_info() and statistics_info(). I am trying to determine if things like collate, constraints, etc will be available and I am having problems getting a connection working.

Cheers - L~R

Comment on Re^2: Generate A DDL From Access

Replies are listed 'Best First'.
Re^3: Generate A DDL From Access by remiah (Hermit) on Mar 04, 2012 at 01:54 UTC
I am not sure about collate. If you find one, please tell me. Here is my code. Method "describe" calls collumn_info() and statistics_info(). Read more... (6 kB) And my quistion: I want to make a package which treats MS access dialect (they treat '' for '%' and no limit, offset keyword). Package which can do like this. `my $db=connect(\%dbinfo) or die $!; my $sql ="select from test1 where fld1 like 'monk%' offset 10 limit +10"; foreach my $r ( $db->fetch($sql) ){ print "$r->{fld1}\n"; } $db->disconnect;` [download] I want to make a package which can easily switch MS Access and other database like SQLite. I am interested in DBIX::Class but I am not sure it is the way to go... If you have some advice for me, I am glad. Any comments, advice, welcome.	[reply] [d/l] [select]

Replies are listed 'Best First'.

Re^3: Generate A DDL From Access
by remiah (Hermit) on Mar 04, 2012 at 01:54 UTC

I am not sure about collate. If you find one, please tell me. Here is my code. Method "describe" calls collumn_info() and statistics_info().

Read more... (6 kB)

And my quistion: I want to make a package which treats MS access dialect (they treat '*' for '%' and no limit, offset keyword). Package which can do like this.

my $db=connect(\%dbinfo) or die $!;
my $sql ="select * from test1 where fld1 like 'monk%' offset 10 limit 
+10";
foreach my $r ( $db->fetch($sql) ){
    print "$r->{fld1}\n";
}
$db->disconnect;
[download]

[reply]
[d/l]
[select]