Hi Jeff, [...] >>The first one probably can only be answered by the quthor himself >> >That's me.
I know :) Thx for developing this module. Even if I can't use it in this case, it will help me for future scripts! >>: Will >>SQL::Statement be able to understand the "ALTER" command in the >>future >> >Yes but not any time soon unless someone wants to collaborate on it or >send patches. [...] >It's not too hard to add support for that to the parser but it's a bit >more involved than what you show. IC, but I guess, it nevertheless will be too hard for me. [...] >At the moment SQL::Statement is much better at DML than it is at DDL. >Primary key is recognized as a column definition e.g. "pid INT PRIMARY >KEY" but not as a table defnition e.g. "PRIMARY KEY (col1,col2)". [...] >In general, SQL::Statement is meant to work that way. But given the fact >that you are dealing mostly with DDL and that's SQL::Statement's weakest >point, I recommend you look at SQL::Translator which has very robust DDL >handling (but little or no DML handling). If you have both complex DDL >and DML you may need to use both modules. Thx for this hint. I will give SQL::Translator a try. [...] >Good luck! Thx for your answer. >-- >Jeff Bye. Michael. -- Michael Hirmke | Telefon +49 (911) 557999 Wilhelm-Spaeth-Strasse 52 | FAX +49 (911) 557664 90461 Nuernberg | E-Mail mailto:[EMAIL PROTECTED] | WWW http://www.hirmke.de/
