Subject Re: [IBO] TIBOTable and Generators
Author Don Gollahon
I think I figured it out. I just assign a default value of 0 using Field
Properties so it doesn't get an error. That value is automatically replaced
when the trigger fires when the insert is performed.

Thanks.

""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/
>
>
>