- Code: Select all Expand viewCollapse view
CREATE TABLE "tbl_customers" ("customer_id" INTEGER IDENTITY, "first_name" VARCHAR(50), "last_name" VARCHAR(50), "phone" VARCHAR(25), "email" VARCHAR(30), PRIMARY KEY ("customer_id"));
This code has been verified by three different sources as a valid and workable command and has been tested in Open Office 4.1.3, which is the same version I have installed on my Windows 7 computer.
Whatever I do, the following error message is shown:
- Code: Select all Expand viewCollapse view
1: syntax error, unexpected NAME, expecting ')' or ','
Why is this command not working (and only on my computer apparently). At this point I doubt that the command is wrong, I believe there is something else. Maybe my installation, maybe something I don't know. I have uninstalled and reinstalled Open Office too, but it didn't change anything.