At 12:43 PM 20-08-01 +0000, you wrote:

>The colum is not calculated. The table is as follows:
>
>CREATE TABLE Assay (
> assayID DOUBLE PRECISION NOT NULL,
> assayNo CHAR(10),
> name CHAR(30),
> assayCategoryID DOUBLE PRECISION,
> displayPos INTEGER
>);
>
>The query is SELECT * from ASSAY
>
>where DISPLAYPOS is the field causing problems...

I can't reproduce this in 4.2.Eb at all.

Have you double-checked that both the Datasource and Datafield on the edit box are correct?

Do you know for sure that the column in question is there?

Do you get the same result if your SQL statement selects the full column list instead?

Can you access that column in the Column Editor of the dataset?

Is there any READONLY attribute set for it, e.g. READONLY or NOEDIT?

If you double-click on the connection component to bring up the interactive display (IB_SQL), then invoke the database object browser, are you able to edit the column there? (You can rollback any test change by hitting the cancel button...)

Can you see the existing value in the edit box?

More questions, no answers yet...

rgds,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________