Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine

Re^2: Generate A DDL From Access

by Limbic~Region (Chancellor)
on Mar 03, 2012 at 17:00 UTC ( #957693=note: print w/replies, xml ) Need Help??

in reply to Re: Generate A DDL From Access
in thread Generate A DDL From Access

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

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().

    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;
    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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://957693]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (2)
As of 2018-11-14 02:32 GMT
Find Nodes?
    Voting Booth?
    My code is most likely broken because:

    Results (161 votes). Check out past polls.