https://bugs.freedesktop.org/show_bug.cgi?id=65359

Oliver <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #1 from Oliver <[email protected]> ---
I have typed the next block of code into Writer and then copied and psted
across. This does not now crash the program, but when executed gives the error
message

1: Unexpected token: “ in statement [

CREATE TABLE ]

In the status box. No Outputs are registered.

The code at this stage is:

DROP TABLE "Patient Medication" IF EXISTS;
DROP TABLE "Medication" IF EXISTS;
DROP TABLE "Payment" IF EXISTS;
DROP TABLE "Schedule" IF EXISTS;
DROP TABLE "Assignment" IF EXISTS;
DROP TABLE "Therapists Number" IF EXISTS;
DROP TABLE "Phone Number" IF EXISTS;
DROP TABLE "Patient" IF EXISTS;
DROP TABLE "Psychiatrist" IF EXISTS;
DROP TABLE "Medical Doctor" IF EXISTS;
DROP TABLE "Therapist" IF EXISTS;

CREATE TABLE “Psychiatrist” (
“ID Number” INTEGER GENERATED BY DEFAULT AS INDETITY(START WITH 0) NOT NULL
PRIMARY KEY,
“First Name” VARCHAR(25) NOT NULL,
“Surname” VARCHAR (25) NOT NULL,
“Gender” CHAR(6),
“Street and Number” VARCHAR(50),
“City” VARCHAR(25),
“Postal Code” CHAR(5),
“State” CHAR(2),
“Phone Number” VARCHAR(10)
);

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to