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@...>
To: <IBObjects@yahoogroups.com>
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