Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT ACCESS
Spurious error on select: complains about date format
Keith McMillan
2006-09-15 11:59:07.0
Greetings,

I was experiencing some update problems with the Access 3.0 JDBC driver, build date 9/5/2006. I decided to update to the latest build, dated on the website as 9/15. When I try to select from a table, the driver now complains that I've used an invalid format for a date column. The value that the driver complains about is "CPY" which is a value not in a date column, but in a column next to a date column.

I've already uploaded the database to your anonymous FTP server for you to use, it's called "Empty Copy of Duty Disability.mdb". Here is the sql command that is not working:

select * from tbl_be_tax_rtn

Before updating, I was occasionally getting an error message about my SQL statement "not having any parameter", but this was intermittent. Is this something you've seen before?

thanks,
Keith McMillan
Re:Spurious error on select: complains about date format
HXTT Support
2006-09-15 20:14:53.0
That issue exists only in the v2.0.015 JDBC30 package on September 15, 2006, because some new complemented code. Fixed. Thanks. Please download the latest package.
Re:Re:Spurious error on select: complains about date format
HXTT Support
2006-09-15 20:24:52.0
>Before updating, I was occasionally getting an error message about my SQL
> statement "not having any parameter", but this was intermittent. Is this
> something you've seen before?
Are you meeting "Your statment hasn't any parameter" message? It can be thrown by PreparedStatement and CallableStatement when you call PreparedStatement.setXXX(...) or CallableStatement.registerOutParameter(..) for a sql which hasn't any in/out parameter. What's your code?

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap