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/

Reply via email to