Subject Re: [IBO] Quoted fields seem to be broken in TIBODataset when they're involved in indexing
Author Hans
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