Subject | RE: [IBO] Working with Generators |
---|---|
Author | Norman Dunbar |
Post date | 2002-04-11T11:33:20Z |
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.
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.