> I have run into a problem when modifying a table by > adding column names > that when I save it all of my add column names are > gone. I had added 50 > names and saved - all add names lost. However, if I > add 4 or 5 column > names no problem.
Were you running with messages on or off? I've noticed, when you modify a table structure and add something that is invalid, so that the table cannot be saved, when you get informed about the error there is no way to cancel the failed save operation, and you wind up with your original, unmodified table structure. This is true even though there is a cancel option on the dialog. I haven't had time to pin down a reproducible example in ConComp, when I do (and if I am able to) I will report it to RDCC. > Another problem - went to modify length of field > system in a number of > tables, the system created temporary tables > beginning with 4414. The > only way to get rid of them was to unload the > database and go into the > data file and delete the temporary tables and their > descriptions. I wouldn't be surprised if the name SYSTEM was a reserved word. Do you have ANSI on or off? -- Larry
