Subject | Re: [IBO] Quoted fields seem to be broken in TIBODataset when they're involved in indexing |
---|---|
Author | Hans |
Post date | 2006-07-29T03:03:03Z |
I tried in IB_SQL
CREATE TABLE ARINV (
"Acc ID" INTEGER NOT NULL,
"Invoice #" VARCHAR(25) NOT NULL,
"Date" DATE NOT NULL,
"Sub Total" NUMERIC,
"Tax" NUMERIC,
"Freight" NUMERIC,
"Total" NUMERIC,
CONSTRAINT PK_ARINV PRIMARY KEY ("Acc ID", "Invoice #","Date")
)
which errors off with error invalid integer number. However it create a
table ARINV, which
causes nothing but errors when you even try to view it source.
Changing from "Invoice #' to "Invoice No"
CREATE TABLE ARINV (
"Acc ID" INTEGER NOT NULL,
"Invoice No" VARCHAR(25) NOT NULL,
"Date" DATE NOT NULL,
"Sub Total" NUMERIC,
"Tax" NUMERIC,
"Freight" NUMERIC,
"Total" NUMERIC,
CONSTRAINT PK_ARINV PRIMARY KEY ("Acc ID", "Invoice No","Date")
)
Creates a table ARINV, which I can view the source.
Thus I believe your problems already start at table creation.
This is on version IBO4.3i, IBO4.5 and IBO4.6Ac
CREATE TABLE ARINV (
"Acc ID" INTEGER NOT NULL,
"Invoice #" VARCHAR(25) NOT NULL,
"Date" DATE NOT NULL,
"Sub Total" NUMERIC,
"Tax" NUMERIC,
"Freight" NUMERIC,
"Total" NUMERIC,
CONSTRAINT PK_ARINV PRIMARY KEY ("Acc ID", "Invoice #","Date")
)
which errors off with error invalid integer number. However it create a
table ARINV, which
causes nothing but errors when you even try to view it source.
Changing from "Invoice #' to "Invoice No"
CREATE TABLE ARINV (
"Acc ID" INTEGER NOT NULL,
"Invoice No" VARCHAR(25) NOT NULL,
"Date" DATE NOT NULL,
"Sub Total" NUMERIC,
"Tax" NUMERIC,
"Freight" NUMERIC,
"Total" NUMERIC,
CONSTRAINT PK_ARINV PRIMARY KEY ("Acc ID", "Invoice No","Date")
)
Creates a table ARINV, which I can view the source.
Thus I believe your problems already start at table creation.
This is on version IBO4.3i, IBO4.5 and IBO4.6Ac