posted 19 years ago
hello to all, we've been using "DATE" as datatype before in our database and havn't encountered an error regarding it, just this evening i visited a prevoiusly worked on project and this is the error encountered..
===============================
sql->SELECT * FROM DAILYTIMERECORD
SQLException at initialize: [interclient][interbase] Dynamic SQL Error
SQL error code = -804
Data type unknown
Client SQL dialect 1 does not support reference to DATE datatype
interbase.interclient.SQLException: [interclient][interbase] Dynamic SQL Error
SQL error code = -804
Data type unknown
Client SQL dialect 1 does not support reference to DATE datatype
at interbase.interclient.RecvMessage.createSQLException(Unknown Source)
at interbase.interclient.RecvMessage.makeSQLException(Unknown Source)
at interbase.interclient.RecvMessage.get_EXCEPTIONS(Unknown Source)
at interbase.interclient.PreparedStatement.remote_PREPARE_STATEMENT(Unknown Source)
at interbase.interclient.PreparedStatement.<init>(Unknown Source)
at interbase.interclient.Connection.prepareStatement(Unknown Source)
at payroll.cdrdtr.DtrDataManager.executeQuery(DtrDataManager.java:271)
at payroll.cdrdtr.DtrDataManager.initialize(DtrDataManager.java:247)
at payroll.cdrdtr.DtrDataManager.init(DtrDataManager.java:29)
at payroll.cdrdtr.DtrDataManager.<init>(DtrDataManager.java:22)
at payroll.cdrdtr.MainFrame.getInitialInformation(MainFrame.java:814)
at payroll.cdrdtr.MainFrame.<init>(MainFrame.java:106)
at payroll.cdrdtr.MainFrame.main(MainFrame.java:528)
============================
im on windows xp sp2
jdk 1.3.x
eclipse 3.1
any lights ??