Subject RE: [IBO] Working with Generators
Author Norman Dunbar

in each of your queries set the GeneratorLinks parameters to :


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 :




Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
Tel: 0113 289 6265
Fax: 0113 289 3146

-----Original Message-----
From: Edson Luis Gonçalez [mailto:edson@...]
Sent: Thursday, April 11, 2002 12:28 PM
Subject: [IBO] Working with Generators


I have many queries in a form, to manager addresses, and
all relations like:

PAISES (like country)
ESTADOS (like states)

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 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.


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

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
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.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to

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.