CREATE TABLE IF NOT EXISTS "ProcedureMGR"
(
   "OID" GUID DEFAULT CURRENT_GUID,
   "Code" VARCHAR(10),
   "Version" VARCHAR(10),
   "Description" VARCHAR(30),
   "Active" BOOLEAN DEFAULT True,
   "Facility" VARCHAR(10),
   "Setup Hours" FLOAT DEFAULT 0,
   "Procedure Hours" FLOAT DEFAULT 0,
   "Cleanup Hours" FLOAT DEFAULT 0,
   "End Time" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
   "Notes" MEMO,
   "CreatedBy" VARCHAR(30),
   "Created" TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
   "EventCount" INTEGER DEFAULT 0,
   "First Performed" DATE DEFAULT CURRENT_DATE,
   "Last Performed" DATE DEFAULT CURRENT_DATE,
   "Actual Setup Hours" FLOAT,
   "Actual Procedure Hours" FLOAT,
   "Actual CleanUp Hours" FLOAT,
   "Surgeon" VARCHAR(10),
   "Anestelsiolist" VARCHAR(10),
   "Patient Type" VARCHAR(10),
PRIMARY KEY ("OID") COMPRESS NONE
LOCALE CODE 0
USER MAJOR VERSION 1
);

CREATE INDEX IF NOT EXISTS "Code" ON "ProcedureMGR" ("Code");
CREATE INDEX IF NOT EXISTS "Active" ON "ProcedureMGR" ("Active");
CREATE INDEX IF NOT EXISTS "MainKey" ON "ProcedureMGR" ("Code",
"Version");
CREATE INDEX IF NOT EXISTS "Surgeon" ON "ProcedureMGR" ("Surgeon");
CREATE INDEX IF NOT EXISTS "Type" ON "ProcedureMGR" ("Patient Type");
CREATE INDEX IF NOT EXISTS "Description" ON "ProcedureMGR" 
("Description");

---

 Comments and Workarounds

---

The normal LOCALE clause without the CODE keyword and with a locale name instead works fine.

---

 Resolution

---

Fixed Problem on 12/19/2003 in version 4.02 build 1