Subject Re: [IBO] Re: Update Query Problem
Author Helen Borrie
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,
>SET DESCRIPTION = ' + QuotedStr('Test')
>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
>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.