Главная страница | назад





Article #17852: Query with a string does not work properly

 Question and Answer Database

FAQ2852D.txt - Query with a string does not work properly

Category   :AS400
Platform   :All-32Bit
Product    :DelphiAS400,   

Question:
I am doing a Query against the 400 where I specify a string, 
example:  SELECT * FROM CUST WHERE CUSTNAME = "Sparky"
  But it is not working properly.  What am I doing wrong?


Answer:
The 400 likes Single Quotes and not double quotes.  
You should be doing:

  SELECT * FROM CUST 
  WHERE CUSTNAME = 'Sparky'


4/1/99 2:46:02 PM
 

Last Modified: 01-SEP-99