Subject Re: [IBO] Working with Generators
Author Luiz
Did you fill the GeneratorLinks property to the query?
There is samples in IBO package showing how to do it.
The help file also can be usefull.

Luiz.
----- Original Message -----
From: "Edson Luis Gonçalez" <edson@...>
To: <ibobjects@yahoogroups.com>
Sent: Thursday, April 11, 2002 8:27 AM
Subject: [IBO] Working with Generators


> Hello.
>
> I have many queries in a form, to manager addresses, and
> all relations like:
>
> PAISES (like country)
> |
> ESTADOS (like states)
> |
> CIDADES
> ...
>
> I try to insert into COUNTRY and press save button or F10.
> A trigger in ActionList (default dataset commands) are fired,
> posting data.
> I have the property commit on post status active.
> The problem is....my ID (primary key) is entered
> by a generator.
> I'm posting, but the value of PAISES_ID (pk) isn't retrieved
> for me.
> If i try to insert a new field in ESTADOS (detail from PAISES)
> occours an error saying the field paises_id is missing.
> I manually have to create a function, to execute a sql statement
> and retrieve value for specific generator.
> I fire this function in BeforePost for any table.
> Now is all right, but... what's the correct way do
> work with generators and see in my current transaction in
> visual mode too ?
>
> Note: Using refresh, refreshkeys... the value is show, but
> i miss the position record... this back to 1st record.
>
> Regards.
>
> Edson Luis Gonçalez
> Ribeirão Preto / SP / Brazil