Re: SQL syntax with apostrophes

       exec sql
        update aaakey
         set comx=1
         where loc='a';
Field comx should really be comp.

Source type is SQLRPGLE.
Source, Syntax Check all returns:  Syntax check action completed with no 
errors.

Windows, Preferences, Remote Systems, iSeries, LPEX Editor Parsers, ILE 
RPG, has both Automatic syntax checking and Automatic syntax checking of 
SQL statements (performed on the server) checked on.

I tried selecting the offending code, highlighting it, right clicking and 
selecting Syntax Check Selection and it passed with flying colors.  If 
however, I change the whole line from
       exec sql
        update aaakey
         set comx=1
         where loc='a';
to
       exec sql
        biteme
        update aaakey
         set comx=1
         where loc='a';

Then it lets me know there is an error.

Rob Berendt