Re: sql and screen fields

Isn't there is a compile option that does additional pre-compiler
expansion of the source. Something like LEVEL1 or LEVEL2. Prompt the
command, don't have access now to try it.


On 10/11/2024 12:05 PM, Jay Vaughn wrote:

at least the different versions are the only thing I can see that's in
play...(I really don't think it is a vers thing)

thanks

Jay

On Fri, Oct 11, 2024 at 11:31 AM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

I get you Patrik, but really this is a very siimple one to describe.

If you have an rpg pgm and a dspf, and a screen field in a rcdfmt of the
dspf...
and in your pgm you do...

exec sql
select tableColumn
into :screenField
from mylib/mytable

the compile listing shows...

position 28 variable xxxxx not defined or not usable.
reason: no declaration for the variable exists, the declaration is not
within the current scope, or not variable does not have an equivalent

sql

data type.

this happens on 7.2 but not 7.4

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.