Re: SQL precompiler problem?

This is from the DBGVIEW of a SQLRPGLE. The embedded SQL Statement is shown
commented out and then the generated code. You can see that the SQL
Statement has :C.GHRID but the generated SQL shows only GHRID. This really
screws up the program as you can imagine. Anyone seen this before?

145000 //* exec sql select plt into :plt

145100 //* from locplt00

145200 //* where rid=:c.ghrid and bld=:locrec.bld and
sec=:locrec.sec
145300 //* and ais=:locrec.ais and slt=:locrec.slt and
lvl=:locrec.lvl;
145300 SQL_00005 = GHRID;

145300 SQL_00006 = LOCREC.BLD;

145300 SQL_00007 = LOCREC.SEC;

145300 SQL_00008 = LOCREC.AIS;

145300 SQL_00009 = LOCREC.SLT;

145300 SQL_00010 = LOCREC.LVL;
--
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.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com