Re: dbdiff2 - ALTER TABLE patch

Folks, Evidently some versions of isql out there don't like not having parentheses around the column name(s) to be affected in the ALTER TABLE section. Robert Minter has come up with a correction - which will be applied verbatim in future versions but for those of you having trouble with it NOW... } } The line ( approx. 449 ): } LET strg = "DROP ", chk_cols[i].n_colname clipped } causes syntax error on our 4.10. } } should be: } LET strg = "DROP (", chk_cols[i].n_colname clipped," )" } } Also, the line ( approx. 462 ): } -- LET strg = "ADD ", } LET strg = "ADD (", } } chk_cols[i].o_colname clipped, } column 27, strg clipped, } } And the line ( approx. 465 ): } -- " BEFORE ", chk_cols[k].n_colname } " BEFORE ", chk_cols[k].n_colname clipped, " )" } } Line ( approx. 471 ): } -- LET strg = "ADD ", } LET strg = "ADD (", } } chk_cols[i].o_colname clipped, } column 27, } } Line ( approx. 474 ): } -- col_cnvrt(chk_cols[i].o_coltype, chk_cols[i].o_collength), } col_cnvrt(chk_cols[i].o_coltype, chk_cols[i].o_collength) clipped, " ) " } } } And lastly ( approx. 499 ): } -- LET strg = "MODIFY ", } LET strg = "MODIFY (", } } chk_cols[i].n_colname clipped, } column 27, } } And line ( approx. 502 ): } -- col_cnvrt(chk_cols[i].o_coltype,chk_cols[i].o_collength), } col_cnvrt(chk_cols[i].o_coltype, chk_cols[i].o_collength) clipped, " )" } } This is what we did to make it work. What you do might be different. Just } our example. } } Robert Minter |Data Systems Support| \\\\\\_/// } Programmer, Software Development | Orange, CA | ( _ _ ) } internet: rob@dssmktg.com | Tel: 714.771.0454 | (| ^ |) } bangpath: uunet.uu.net!dssmktg!rob| Fax: 714.771.3028 | \\`-'/ } #include <disclaimer.h> \\_/ } cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| Domini, Domini, Domini jparker@hpbs3645.boi.hp.com | you're all Catholic now. (208) 396-5388 (W) (208) 384-1623 (H) | - FT _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________