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