Hi,

I have found the solution.

I have changed the type of the Nivel field from Char type to varchar
(8) type but have forgotten to remove all the fields of the
Collection Editor of the IBSQL attached to the ClientDataset before
adding the Nivel field with the new type on the Collection Editor of
the Clientdataset.

Thanks.

Marcelo.

--- In ib-support@y..., "mcrosman1957" <delphi7@b...> wrote:
> Hi,
>
> I am using Delphi 6 Ent. and Firebird 1.0.0.338.
>
> I have created a table PLANCONORC as:
>
> CREATE TABLE PlanConOrc
> (
> NumReg SMALLINT NOT NULL,
> Nivel VARCHAR(8) NOT NULL, <==Problem with
this field
> Code VARCHAR(7) NOT NULL UNIQUE,
> Conta VARCHAR(40) NOT NULL,
> Tipo VARCHAR(2),
> PRIMARY KEY (NumReg)
> );
>
> I am using a datamodule with:
>
> 1 ClientDataset
> 1 DatasetProvider
> 1 IBQuery
> 1 IBTransaction
> 1 IBDatabase
>
> When I open the Collection Editor of the ClientDataset and Add All
> Fields there is a problem with the Nivel (TStringField) field.
>
> Nivel field is a VARCHAR(8) type and not a Char type.
>
> In the Collection Editor when I select the Nivel field the
following
> properties are shown as:
>
> FixedChar = True (This specifies that Nivel field is a Char Type
and
> Not a VARCHAR type)
>
> Size = 1 (NOT 8)
>
> The other varchar fields of the table PLANCONORC: Code, Conta, Tipo
> are fine.
>
> Why is it hapenning with the Nivel field?
>
> When I try to assign a 8 character string to Nivel the folowing
error
> occurs: Field size mismatch.
>
> Could anyone help me solve this problem?
>
> Thank you all.
>
> Marcelo.