Consultor Eletrônico



Kbase P17731: SQL-92: Too many values specified (7531)
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   3/19/2003
Status: Unverified

FACT(s) (Environment):

Progress 9.1D

SYMPTOM(s):

Too many values specified (7531)

Using the CASE or DECODE function returns error 7531.

CAUSE:

Currently there is a limit of 100 arguments for the CASE and DECODE functions.

FIX:

Keep the arguments below 100 or try to workaround the limit by nesting different CASE or DECODE functions.