[Sorensson]

Thank you, Cal.

I shall try that. Meanwhile, I have managed to find the R:Base (rather than rBase) discs and loaded it to C: via Command Prompt on Win2K.

R:Base can “Unload”, in their terminology, in CSV ASCII format. So, it will be possible to import the CSV files to MySQL and I am off and running.

Apart from the fact that it is a DOS-based system, R:Base may have the features I need to manipulate my data. Immediately, no one else will be working with the material so I may forego transfer to MySQL until such time as someone else, lacking R:Base, wants to monkey with it.

[Sorensson]

Defeated, if not corrected, Alter Table problem by killing MySQL and restarting. Came upon this dodge after killing the machine to replace a cable.

I am attempting to use MySQL on Win2K. Simple stupidity is probable driver of my problems. Now struggling with the following:

Trying to add an 'enum' column to several of the eight tables -again using Alter Table. Works fine on three of four tables (column details are the same in each table). Attempt on fourth table elicits response:

“Error 1064. You have an error in SQL syntax near '.'NotSRB' NULL, drop primary key, add primary key (`StrtNr3`)' at line 1”

“NotSRB” is the last alternative enumerated. Not sure what “NULL” refers to and I have not set the enum column as primary. “StrtNr3” is already set as primary key so the last phrase is puzzling.

In one of the three successfully altered tables, the first alternative (“Excell.”) has been set as Default by SQLyog, but not so in the other two. If I delete that “Excell.”, close Alter Table, and open it again “Excell.” is again the default. This is no real problem, I imagine. But in the other two successfully modified tables, there is no default value chosen for the enum. When I put “Excell” as the default close Alter Table and re-open, it has been deleted.

Thus far, I have found no way to examine the SQL statements implicitly defined and executed when monkeying with Alter Table. I think I have chased down every potential path to the statements. What am I missing?

[Author]

Posts