Subject | Re: Update Query Problem |
---|---|
Author | Malav A Shah |
Post date | 2006-04-17T06:47:44Z |
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.
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.