Base LO ver 4.2.2.1
This is the diagnostic info from clicking “more”:
SQL status 37000 error code: -11
text of the message:
Unexpected token in statement [CREATE TABLE “Table1” (“Chart Number” INTEGER NOT NULL IDENTITY,“body name” VARCHAR(100) NOT NULL,“body abbr” VARCHAR(100),“Longitude” NUMERIC(15,10),“Latitude” NUMERIC(15,10),“Right Ascension” DECIMAL(15,9),“Declination” DECIMAL(15,9),“Azimuth” DECIMAL(15,9),“Altitude” DECIMAL(15,9),“daily travel” DECIMAL(15,9),“Direct/Retro” CHAR(1,]
Okay - I deleted lines and re-entered field defs after I noticed that the generated create command ended with the “char(1,” designation - there were more fields after that which were apparently not recognized. I had been playing with copying and pasting the lines in the design view GUI table def screen. I suspect this is a bug. I got by it with retyping and not defining a field as 1 char (? !). Will report as a bug.
Still having a problem with this error. No chance in saving table (even a simple one, without formating).