--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 08:46 AM 13/08/2006, you wrote:
> >Hi,
> >
> >I've recently move from an older version of IBobjects to the latest.
> >Now, I'm experiencing something weird:
> >
> >I create a TIBOQuery at run-time, when I try to edit the values of a
> >record, it isn't possible anymore... I've checked it and it is because
> >the database field is read-only (the dataset itself is not).
> >
> >If I manually change the readonly value to false, then I can edit the
> >value again and everything works as normal... but it is surely not the
> >idea that I iterate all controls of a form and change it's readonly
> >status to false...
>
> No, it's not. But why would you "iterate all controls of a form" if
> it's a database field that is arriving read-only?

to adjust them to 'not being readonly'...
It's weird, since this issue arrived when using a new version of
IBObjects.

> What is the SQL of this query?

result := 'SELECT PERSONS.PERSON_ID,'+#13#10
+'PERSONS.PERSON_FIRSTNAME,'+#13#10
+'PERSONS.PERSON_SECONDNAME,'+#13#10
+'PERSONS.PERSON_LASTNAME,'+#13#10
+'PERSONS.PERSON_BIRTHDATE,'+#13#10
+'PERSONS.PERSON_STREETNAME,'+#13#10
+'PERSONS.PERSON_STREETNUMBER,'+#13#10
+'PERSONS.PERSON_BUSNUMBER,'+#13#10
+'PERSONS.PERSON_REFUSAL,'+#13#10
+'PERSONS.PERSON_DECIESED,'+#13#10
+'PERSONS.PERSON_CREATED,'+#13#10
+'PERSONS.PERSON_MODIFIED,'+#13#10
+'PERSONS.POSTCODE_ID,'+#13#10
+'POSTCODES.CITY'+#13#10
+'FROM PERSONS'+#13#10
+'LEFT OUTER JOIN POSTCODES ON
PERSONS.POSTCODE_ID=POSTCODES.POSTCODE_ID'+#13#10
+ 'WHERE (PERSON_ID = :PersonID)'

Regards,