Since IB_SQL is a product built by and built on IBObjects,
I think you'll have a problem with the use of a "xxxx #'
fields, since all I basically did was just referencing this field.

----- Original Message -----
From: <firebird@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, July 29, 2006 8:21 AM
Subject: RE: [IBO] Quoted fields seem to be broken in TIBODataset when
they're involved in indexing


>>
>> -----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]
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>