get a data written in a triger

Thread View: borland.public.interbase.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Quique Tue, 10 Dec 2002 00:29

#11187

Author: Quique
Date: Tue, 10 Dec 2002 00:29

9 lines
1131 bytes

Hi

I use a trigger to write an index in a table with a generator,  this trigger
is "before insert" , how can i know the value that the genearator has "after
insert" in Delphi

Thanx for any help
bye
QuiQue

Re: get a data written in a triger

#11193

Author: Frank Gruber
Date: Tue, 10 Dec 2002 10:27

12 lines
1440 bytes

> I use a trigger to write an index in a table with a generator,  this
trigger
> is "before insert" , how can i know the value that the genearator has
"after
> insert" in Delphi

Not possible.
If you are using TIBDataSet you should use the GeneratorFields property
and increment the generator not by the trigger but by the client app.

Regards,
Frank.

Re: get a data written in a triger

#11202

Author: Quique
Date: Tue, 10 Dec 2002 22:12

26 lines
1774 bytes

sorry, i missed the right button

thanx frank, do you know where can i get some information about use
Generator field, because i have D5 and there is no help about this, or if
you can tell me an idea how to use it, i will apreciatte any of those

bye

QuiQue
"Frank Gruber" <HVFDMIPUMFPS@spammotel.com> escribi� en el mensaje
news:3df5c182@newsgroups.borland.com...
> > I use a trigger to write an index in a table with a generator,  this
> trigger
> > is "before insert" , how can i know the value that the genearator has
> "after
> > insert" in Delphi
>
> Not possible.
> If you are using TIBDataSet you should use the GeneratorFields property
> and increment the generator not by the trigger but by the client app.
>
> Regards,
> Frank.
>
>
>

Re: get a data written in a triger

#11203

Author: Don Siders [Team Indy]
Date: Wed, 11 Dec 2002 00:29

18 lines
1806 bytes

> thanx frank, do you know where can i get some information about use
> Generator field, because i have D5 and there is no help about this, or if
> you can tell me an idea how to use it, i will apreciatte any of those

There is if you've installed the May 15 2001 help file.  Mine was installed
with the IBX update.
See the help topics for:

TIBCustomDataSet.GeneratorField
TIBGeneratorField


--
Don Siders

Join the Indy Docs project! (http://www.nevrona.com/indy/teams/docs)

ELKNews - Get your free copy at http://www.atozedsoftware.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads