I changed to a TIBOQuery with the same results. My InsertSql is (it does
not have the key field in it):

INSERT INTO PARTNERINFO(

FIRST_NAME,

MIDDLE_NAME,

LAST_NAME,

...

MAILING_LIST_ONLY)

VALUES (

:FIRST_NAME,

:MIDDLE_NAME,

:LAST_NAME,

...

:MAILING_LIST_ONLY)




""Don Gollahon"" <dlgllhn@...> wrote in message
news:9vlpca$ka9$1@......

> I can't insert a record into a table using TIBOTable because it says it
> needs a value for the key field. I have a generator/trigger setup for

that

> field so I shouldn't have to enter it.
>
> Trigger:
> begin
> if (new.id is null) then
> new.id = gen_id(partnerinfo_id, 1);
> end
>
> ID is the only key field. I'm using TIBOTable because this is an app that
> I've converted from Paradox tables and I use the IndexName property. It
> wouldn't be that hard to change it but I just wondered why the generator
> didn't work.
>
> The ID field is not accessible by the user (except to view it). There is

no

> code on the object to manipulate anything for insert/delete/edit.
>
> Thanks.
>
> --
>
> Don Gollahon
> (dlgllhn@...)
>
>
>
>
>

___________________________________________________________________________

> 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 !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>