I have this table:

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,

... and some more fields, clipped for brevity

CONSTRAINT PK_ARINV PRIMARY KEY ("Acc ID", "Invoice #", "Date")
);


This line of code

tblInvoice.FindNearest( [ID, nil, nil] );

throws an exception that says this:

Cannot access index field 'ARINV."Acc ID" '

from within TIBODataset.SetKeyFields.

Does it want a separate index on each of "Acc ID", "Invoice #"
and "Date"?

Michael D. Spence
Mockingbird Data Systems, Inc.