Re: SQL syntax with apostrophes

Rob,

The SQL syntax check is just that -- a *syntax* check.  It verifies that 
the format of the statement is valid.  It doesn't check that your 
field/column names are correct or that the values being entered are 
legitimate.  I think the performance hit would be too large to verify that 
each time we hit enter.

This works the same as editing RPG.  The editor only flags invalid RPG 
syntax.  Not bad variable names, etc.

Michael

wdsci-l-bounces@xxxxxxxxxxxx wrote on 08/21/2006 01:00:05 PM:

date: Mon, 21 Aug 2006 12:56:47 -0400
from: rob@xxxxxxxxx
subject: Re: [WDSCI-L] 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
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com