Subject Re: [IBO] TIBOTable and Generators
Author hans@hoogstraat.ca
Don Gollahon wrote:
>
> 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/