Weird SQL
  (6-replies, Power system - SQL (general/non-embedded))
Post your reply | Return to Forum  Refresh | ascending | descending
Author: Rocky Return to Forum  Refresh 2010-02-10 14.49.17
Ok - if I prompt the SELECT statement and leave out the ) it adds it in - but 
not if I just enter it in. It's the prompt that says "Hmmm - user  forgot 
the ) I'll put it in for him" - entering it in lets you know your an 
idiot.... :-)
Author: Rocky Return to Forum  Refresh 2010-02-10 14.47.05
I don't get it what is trying to be said - I get the expected error of Token 
<END-OF-STATEMENT> was not valid Valid tokens: ),.

Author: DaleB Return to Forum  Refresh 2010-02-08 07.11.55
When I tried it, it did not add the ). See my error message below...
Author: jservat Return to Forum  Refresh 2010-02-06 18.36.46
Morris is right. SQL sees 'blah' as a field and gently adds a closing ')' to the
statement (V5R3).
Author: Morris Return to Forum  Refresh 2010-02-02 16.33.41
From STRSQL....
Author: DaleB Return to Forum  Refresh 2010-02-02 07.09.37
From where? From STRSQL I get, not unexpectedly, Token <END-OF-STATEMENT> was
not valid. Valid tokens: ) ,.
Author: Morris Return to Forum  Refresh 2010-02-01 15.54.02
This works for me

Select * from table where Fld = Char(blah
Your reply | top | Return to Forum | ascending | descending
      Name:
    
By pressing you agree to the
forum guidelines
      Note: Your message is limited to 3500 characters.