Hi,

It seems this is not a IBO question, but a data-definition question.
Try to run/prepare this query in the other Database Tools (e.g. IBExpert)
and you will get same error.
Are you sure what the field "DESCRIPTION" is not read-only?

Ramil

> hi helen

> I have table Sales which has computed field Net Cost. and i m
> trying to update field Description which changes on the change of
> stock selected by user. I m updating field through TIB_DSQL.

> for example i m writing query in TIB_DSql as follows,

> 'UPDATE SALES
> SET DESCRIPTION = ' + QuotedStr('Test')
> WHERE UNIQUE_KEY = 1'

> When i m tring to Prepare this query it gives me error
> "Attempted to Update Read Only Column"

> Now i have table Ledger which doesn't have any computed fields.
> FOR EXAMPLE In TIB_DSql the query is

> 'UPDATE LEDGER
> SET ACCOUNT_NAME = ' + QUOTEDSTR('MALAV)
> WHERE UNIQUE_KEY = 1'

> Here the query is running fine.

> If you want some more information regarding this my yahoo id
> malav1879@.... and i m online whenever i m in office. I m
> from india and i m online from morning 10 am india time.







> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links



>