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

Article #18022: SQL open error

 Question and Answer Database

FAQ3022D.txt - SQL open error

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

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

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