Subject Re: Update Query Problem
Author Malav A Shah
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.