It works!!

FieldByName('CODIGO_DIREITO').AsFloat := iDireito;
FieldByName('ORDEM').Value := StrToFloat(aOrd[iDireito]);
FieldByName('NIVEL').Value := aNiv[iDireito];
FieldByName('DESCRICAO').Value := aDesc[iDireito];

Thank you!!

Antonio Carlos

PS: Do you still want a simple application?

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> Wow, looks like things should be Ok. What happens if in your code
you use
> the AsInteger, AsString, AsFloat, etc. properties instead of value.
If it
> works this way and not (obviously) the other, I'd like for you to
please
> send me a simple example application showing the problem so I can
isolate it
> and look for something that may need resolving.
>
> Kind regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
>
> ----- Original Message -----
> From: "consultor_cys" <consultor_cys@y...>
> To: <IBObjects@y...>
> Sent: Friday, September 06, 2002 4:47 PM
> Subject: Re: [IBO] TIBOQuery and TIB_Query are completely different?
>
>
> > OK. Here's part of the code:
> > ----------------------------------------------------
> >
> > // qDireito = TIBOQuery with internal UpdateSQL
> >
> > for iDireito := 1 to 10 do begin
> > with DM.qDireito do begin
> > Insert;
> > FieldByName('CODIGO_DIREITO').Value := iDireito;
> > FieldByName('ORDEM').Value := StrToFloat(aOrd[iDireito]);
> > FieldByName('NIVEL').Value := aNiv[iDireito];
> > FieldByName('DESCRICAO').Value := aDesc[iDireito];
> > Post;
> > end;
> > end;
> >
> > ----------------------------------------------------
> > Here's is the table definition:
> > ----------------------------------------------------
> >
> > CREATE TABLE L_DIREITO (
> > CODIGO_DIREITO DECIMAL(18,0) NOT NULL
> > , ORDEM DECIMAL(18,0)
> > , NIVEL VARCHAR(2)
> > , DESCRICAO VARCHAR(100)
> > , NOME_MODULO VARCHAR(100)
> > , CONSTRAINT PK_L_DIREITO PRIMARY KEY (CODIGO_DIREITO)
> > );
> >
> > ----------------------------------------------------
> >
> > --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > > My guess is that you simply are not providing the value for the
> > column on
> > > the client-side prior to the post.
> > > Will you please tell us a little more about your situation so
we can
> > > recommend what we do that works?
> > >
> > > Thanks,
> > > Jason Wharton
> > > CPS - Mesa AZ
> > > http://www.ibobjects.com