June 20, 2006, 08:09 PM
krishkasiA CONSTANT REQUIRES A REAL FIELD ON THE LEFT SIDE. USE WITH : Y
Am working on version 714. While executing a report via reportcaster, am getting below error message.
A CONSTANT REQUIRES A REAL FIELD ON THE LEFT SIDE. USE WITH : Y
The report is executing fine in MRE.
Can anyone of you help me resolving this error.
Thank you so much in advance.
June 20, 2006, 11:49 PM
susannahKrishkasi
we need to see your DEFINEs.
You have a constant defined somewhere
and it needs to be defined along with some real fieldname from the segment where you want the constant to exist so that focus knows which segment it belongs to.
DEFINE FILE yourfile
MYFIELD/I4 WITH somefieldname = 1 ;
END
June 21, 2006, 08:32 AM
LeahAs Susannah says, Focus needs to know 'when' to define, so need real field. You are being bit by the differences in the MRE and Caster world of WebFOCUS, there are somethings you can get away with in MRE that you can't in caster. My one issue with the product since we went to WebFOCUS has been this 'difference'.
June 27, 2006, 07:23 PM
krishkasiDear Susannah and Leah,
have figured out the problem and forgot to post my findings..
Spelling mistake in the column name gave out this error.
It may look funny but this was the problem...
My report looks as follows
SQL
SELECT
COLUMNA AS COLUMNA
FROM TABLEA
WITH UR;
TABLE FILE SQLOUT
PRINT *
ON TABLE HOLD AS TABLEB
END
TABLE FILE TABLEB
PRINT COLUMNAS
-* SEE THE ADDITIONAL 'S' HERE TO THE COLUMN
ON TABLE SET STYLE *
styles
ENDSTYLE
END
Above code was working fine in MRE. But if i ran it through the reportcaster, it gave out the abovesaid error. "A CONSTANT REQUIRES A REAL FIELD ON THE LEFT SIDE. USE WITH : Y"
June 28, 2006, 09:15 AM
LeahI can empathize completely. Just went through an issue helping with some code and why a join wasn't working. Turns out the 7.1.x version we use doesn't like JOIN CLEAR* unless you have a space before the *. Very old code from mainframe days. The message indicated there must be something wrong with the join just after. Such a nightmare.