Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid

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]
[Corion]: Wheee! The videos of the German Perl Workshop 2018 are online :)

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (10)
As of 2018-07-23 15:55 GMT
Find Nodes?
    Voting Booth?
    It has been suggested to rename Perl 6 in order to boost its marketing potential. Which name would you prefer?

    Results (471 votes). Check out past polls.