• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL error code = -804

 
Kent Emia
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ??
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic