Subject Re: [IBO] TIBOQuery and TIB_Query are completely different?
Author consultor_cys
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
>
> -- 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 1:02 PM
> Subject: [IBO] TIBOQuery and TIB_Query are completely different?
>
>
> > I have a big problem: TIBOQuery and TIB_Query doesn't have the
same
> > behavior.
> >
> > I'm evaluating IBObjects and, at the first try I'm getting
the "Field
> > xxx must have a value" error with TIBOQuery/TIBOTable. I tryed
> > everything: I wrote the sql by my own; used parameters in SQL;
> > changed the required field property to false (in design and run
> > time), with no sucess.
> >
> > And now I tryed to use the TIB_Query, exactly as I was using
> > TIBOQuery, and IT WORKS! The error is gone.
> >
> > Anybody could, please, tell me why?
> > What I'm doing wrong?
> >
> > Thank you all
> >
> > Antonio Carlos