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





Article #18022: SQL open error

 Question and Answer Database

FAQ3022D.txt - SQL open error

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

Question:
How come I'm getting the error "SQL open error" when using 
a TQuery400 or TSQL400 containing a Date Field? 

Answer:
Check the date formatting. For example, 
'WHERE DTINVOICE='96-02-15', the format should be 
'WHERE DTInvoice='1996-02-25'. 


4/2/99 12:19:22 PM
 

Last Modified: 01-SEP-99