Subject Re: [IBO] Again: Problem with GeneratorLinks
Author Jason Wharton
Not sure since it works fine for me.
You must be doing something to erase its value.
Write a program to isolate the problem and find out if it is receiving the
value and if it is, then find out where it is losing it between then and
posting it to the server. Once you get this far, I'll be happy to hear more.

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "helton_o" <helton_o@...>
To: "IBObjects" <IBObjects@yahoogroups.com>
Sent: Thursday, May 16, 2002 4:40 AM
Subject: [IBO] Again: Problem with GeneratorLinks


> Sorry, i forgot to send my configuration: Delphi 5, Win2K Service
> Pack 2 and IBO 4.2.Gd
>
> Thanks in advance.
>
> Helton
>
> > Hi all,
> >
> > I have the following table:
> >
> > CREATE TABLE IntContabil
> > (
> > Ano SMALLINT NOT NULL ,
> > IdContaCont INTEGER NOT NULL ,
> > ContaCont VARCHAR(18) NOT NULL ,
> > Descricao VARCHAR(25) NOT NULL ,
> > HistPad SMALLINT NOT NULL ,
> > CodReduzido VARCHAR(06) NOT NULL ,
> > PercSobreEvtos NUMERIC(5,2) NOT NULL ,
> > CredoraDevedora CHAR(1) NOT NULL ,
> > GlobalCCusto CHAR(1) NOT NULL ,
> > Evt1 SMALLINT NOT NULL
> > )
> >
> > I would like the field "IdContaCont" incremented in a TIB_
> > Query by the 'GEN_INTCONTABIL'.
> > So the GeneratorLinks property = 'IDCONTACONT=GEN_INTCONTABIL'
> > When i insert a new record i get the following in a TIB_Monitor:
> >
> > '/*---'
> > 'PREPARE STATEMENT'
> > 'TR_HANDLE = 19553948'
> > 'STMT_HANDLE = 19549896'
> > 'SELECT GEN_ID ( GEN_INTCONTABIL, 1 )'
> > 'FROM RDB$DATABASE'
> > 'PLAN (RDB$DATABASE NATURAL)'
> > 'FIELDS = [ Version 1 SQLd 1 SQLn 1'
> > ' GEN_ID = 0 ]'
> > 'SECONDS = 0,030'
> > '----*/'
> >
> > '/*---'
> > 'EXECUTE2 DSQL'
> > 'TR_HANDLE = 19553948'
> > 'STMT_HANDLE = 19549896'
> > 'PARAMS = [ ]'
> > 'FIELDS = [ Version 1 SQLd 1 SQLn 1'
> > ' GEN_ID = 40 ]
> > 'SELECT COUNT: 1
> > 'SECONDS = 0,010'
> > '----*/'
> >
> > Until here it's all rigth, but when i post the record i get:
> >
> > '/*---'
> > 'EXECUTE STATEMENT'
> > 'TR_HANDLE = 19553948'
> > 'STMT_HANDLE = 19545568'
> > 'PARAMS = [ Version 1 SQLd 159 SQLn 159'
> > ' INTCONTABIL.ANO = 2002'
> > ' INTCONTABIL.IDCONTACONT = 0'
> > ' INTCONTABIL.CONTACONT = '3333''
> > ' INTCONTABIL.DESCRICAO = '33''
> > ' INTCONTABIL.HISTPAD = 3'
> > ' INTCONTABIL.CODREDUZIDO = '3'
> > ' INTCONTABIL.PERCSOBREEVTOS = 3'
> > ' INTCONTABIL.CREDORADEVEDORA = 'C'
> > ' INTCONTABIL.GLOBALCCUSTO = 'G'
> > ' INTCONTABIL.EVT1 = 1'
> > 'SECONDS = 0,010'
> > '----*/'
> >
> > As you can see, the generator used in the GeneratorLinks property
> > isn't assigned to the field "IdContaCont" !!
> >
> > What i am missing ?
> >
> > Helton