RE: SQL RPG Error SQL0312

["Haas, Matt" <Matt.Haas@xxxxxxxxxxxxxxxxxxx>]

Scott,

The SQL precompiler has some limitations on how variables can be defined. Given 
the problems it has with other things (such as data structures), I'm guessing 
that it can't use a variable inside of a display or printer file either.

Matt

-----Original Message-----
From: SHOLMES@xxxxxxxxxxxxxx [mailto:SHOLMES@xxxxxxxxxxxxxx]
Sent: Monday, May 05, 2003 3:52 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL RPG Error SQL0312


I have a display file defined with the following fields REQUSER, REQTS, 
:BROWSER and I have defined it in my RPG Program 
     FWEBHITS  CF   E             WORKSTN 
     F                                     SFILE(SFL1:RRN1) 
     F                                     INFDS(INFO) 
....

Upon a compile It is talking about this SQL construct
C/EXEC SQL 
C+   FETCH NEXT FROM MYCSR 
C+      INTO :REQUSER, :REQTS, :BROWSER 
C/END-EXEC 

And this being the error
  158  Position 20 Host variable REQUSER not defined or not usable
Then the error is repeated again for REQTS, BROWSER.

I have looked through the archives and it appears the one other time this 
came up the field was not defined but in this case it should be from the 
display file right?

Thanks in advance for any ideas/hints

Scott Holmes
Sportcraft, Ltd.