Re: sql and screen fields

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

reason:  no declaration for the variable exists, the declaration is not
with the current scope, or the variable does not have an equivalent sql
data type.

this is that "typical" reason you get sometimes when the var is clearly
present in your program

thanks

Jay

On Fri, Oct 11, 2024 at 9:37 AM <stefan@xxxxxxxxxx> wrote:

> Normally the compiler message includes a reason code?
>
> Best regards
>
> Stefan
>
> --
> No trees were killed in the sending of this message, but a large number of
> electrons were terribly upset.
>
> Stefan Tageson
> +46 732 369934
> stefan@xxxxxxxxxx
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Jay
> Vaughn
> Sent: Friday, October 11, 2024 3:28 PM
> To: RPG programming on the IBM i (AS/400 and iSeries) <
> rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: sql and screen fields
>
> I'm on a 7.2 system and doing the below in my rpgle and it will  not
> compile...
> i'm so used to doing this on other systems... is it a release limitation?
>
>
> select column1
>    into :s2_fld
> from mylib.mfile
>
> where s2_fld is simply a screen field defined in a display file.
> The workstn f-spec exists so it should be able to see it and I am also
> doing a exfmt to that screen record in my pgm.
>
> what is the issue?
>
> the compile issue is the typical sql precompile issue saying the s2_fld
> cannot be used due to data type or whatever... but both are simple char
> fields
>
> tia
>
> Jay
> --
> 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.
>
>
> --
> 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.