Subject Re: [IBO] Working with Generators
Author Edson Luis Gonçalez
Thanks.

I will try in the night.

Edson Luis Gonçalez
Ribeirão Preto / SP / Brazil

----- Original Message -----
From: "Norman Dunbar" <norman.dunbar@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, April 11, 2002 8:33 AM
Subject: RE: [IBO] Working with Generators


> Edson,
>
> in each of your queries set the GeneratorLinks parameters to :
>
> tablename.column=generator_name
>
> now when you do an insert, IBO gets the value of the next generator
number,
> and inserts it into the field for you. This is done before the post, so
when
> you post, the field no longer flags an error.
>
> Your example mnight need :
>
> country.paises_id=name_of_the_correct_generator.
>
>
> HTH
>
> Regards,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar@...
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
> -----Original Message-----
> From: Edson Luis Gonçalez [mailto:edson@...]
> Sent: Thursday, April 11, 2002 12:28 PM
> To: ibobjects@yahoogroups.com
> 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/
>
> This email is intended only for the use of the addressees named above and
> may be confidential or legally privileged. If you are not an addressee
you
> must not read it and must not use any information contained in it, nor
copy
> it, nor inform any person other than Lynx Financial Systems or the
> addressees of its existence or contents. If you have received this email
> and are not a named addressee, please delete it and notify the Lynx
> Financial Systems IT Department on 0113 2892990.
>
>
>
___________________________________________________________________________
> 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