At 04:47 PM 17/04/2006, you wrote:

>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"

Is SALES a table or a view?

>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.

It shouldn't run fine. You have a missing quote after 'MALAV.

>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.

No thanks. If you have more information, post it to the list.

By the way, it would be appreciated if you would stop sending your
various application problems to the Firebird bug-tracker. It makes
already very busy people very annoyed.

Helen