<< 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! >>
My mistake -- the actual problem I ran into last night is that I used a WHILE loop to actually build the CREATE TABLE command -- and around 380 columns the command fragment "C1 REAL, C2 REAL. . ." and so on overran the NOTE size of the variable I was using. << 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'm not suggesting that you use shorter column names -- only that you try to figure out where the problem is to create a reportable incident for RBTI to work on. But just shipping them a copy of the offending database should be enough for them to work on. -- Larry
