Re: sql and screen fields

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

Sam - came to mind and I tried rpgppopt(*lvl2) - but did not help.

Jay

On Fri, Oct 11, 2024 at 1:28 PM Sam_L <lennon_s_j@xxxxxxxxxxx> wrote:

> 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.