Kbase P18022: Attempting to Update Progress record from SQL is generating
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
SYMPTOM(s):
Attempting to Update Progress record from SQL is generating error (7587)
used the following syntax;
UPDATE pub.fafa
SET pub.fafa.acctname = 'HOME TAX',
pub.fafa.deptid = '111'
WHERE pub.fmfa.orgid = 1
and pub.fafa.year = '2002'
and pub.acctno '1010003110111'.
CAUSE:
After Stating the table to be updated (PUB.FAFA) you do not need to identify them in the SET statement.
FIX:
use the following syntax;
UPDATE pub.fafa
SET acctname = 'HOME TAX',
deptid = '111'
WHERE pub.fmfa.orgid = 1
and pub.fafa.year = '2002'
and pub.acctno '1010003110111'.