Subject Re: [IBO] Working with Generators
Author Edson Luis Gonçalez
Sorry .... i not say before, i'm using the TIBODataSet components.

Note: I'm working now in other location.... my Delphi is in my home
i can not test any suggestion now.

Regards.

Edson Luis Gonçalez
Ribeirão Preto / SP

----- 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
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.345 / Virus Database: 193 - Release Date: 09/04/2002
>
>
>
>
___________________________________________________________________________
> 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/
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.345 / Virus Database: 193 - Release Date: 09/04/2002