Larry: I actually am creating the table with one long "create table" syntax. It runs the statement without an error, actually creates the table with all 747 columns, and you can query the sys_columns table and it shows all 747 (until you attempt to insert data), so the command is working! I was pleasantly surprised that a create table command could be that long!
Shorter column names would not be appropriate for me to use because since they are using the browser, with a limit of 18 characters it's already hard enough to differentiate a column that represents "Capsule Tissue Left Anterior" from "Capsule Tissue Left Inferior" !!! Although for kicks I'll try it just to see if that's my problem. I explained to the client what's holding me up, and she is going to ask her staff whether it's okay to split the table in half. The tissue names will be in alphabetical order, so it could be AutopsyA_N and AutopsyM_Z. She said it was okay with her, but she's going to verify... Karen > How are you creating the table, by the way? That many columns is too many > for a CREATE TABLE command -- it overflows the maximum command length. Did > you try the experiment with shorter column names? > > If you can't fix it, perhaps you could decompose it into two or three large, > but smaller than 750 columns, tables and let them work in "Autopsy Part I, > Autopsy Part 2, and Autopsy Part 3. > --
