>
> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On

Behalf Of Hans

> Sent: Friday, July 28, 2006 11:03 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Quoted fields seem to be broken in TIBODataset when

they're involved in indexing

>
>
> 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.
>

It works fine in isql and in EMS SQL Manager for Firebird (which
is what I use), so I'm guessing there's a bug in IB_SQL.

I know these are bogus names, but there are hundreds of them,
referred to in many places in over 1000 source modules, so
changing them is on the list just above rewriting from scratch.

The problem's not with referencing the field, it's with the way
indexes are handled in IBObjects.



Michael D. Spence
Mockingbird Data Systems, Inc.


[Non-text portions of this message have been removed]