Hi Helen--

I appologize for posting it in the wrong group. I wasn't positive
if it was related to FB or IBO. I just assumed there wasn't a bug
in IBO and I was doing something SQL-wise incorrect for FB2.1.

I'll try and properly post in the future.

I've purchased an update for IBO and am waiting on download info.

As for primary keys...my table create is:


/* Table: OWNERS */
CREATE TABLE OWNERS (
OWNERNAME VARCHAR(50),
NOTES BLOB SUB_TYPE 1 SEGMENT SIZE 4096,
UNIQUEKEY VARCHAR(20) NOT NULL,
CREATEDATE VARCHAR(10),
EDITDATE VARCHAR(10),
(etc)
RECPOSTEDBY VARCHAR(20),
CONSTRAINT PK_OWNERS PRIMARY KEY (UNIQUEKEY)
);

CREATE INDEX AK_OWNERSOWNER ON OWNERS(OWNERNAME);


Is this valid and proper for FB2.1? Is this what you meant
by "putting a primary key on the table"?

Thanks for you help!

Slow but sure...Kelly


--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
> Kelly,
>
> At 08:10 12/09/2008, you wrote:
> >I'm not sure if this helps....my version appears to be 4.6Aa
>
> 1. That version of IBO doesn't work with Fb 2 and above
> 2. Even when you upgrade to v.4.8.7 you should put primary keys

on your tables.

> 3. Please stop posting IBO questions to this list, as requested

already yesterday. Use ibobjects@yahoogroups.com You can subscribe
from here: http://www.firebirdsql.org/index.php?op=lists#ibo

>
> ^heLen
>