Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.259
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Cobol 5.0.258
  HXTT DBF 7.1.260
  HXTT Excel 6.1.262
  HXTT Json 1.0.230
  HXTT Paradox 7.1.258
  HXTT PDF 2.0.258
  HXTT Text(CSV) 7.1.258
  HXTT Word 1.1.258
  HXTT XML 4.0.259
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT ACCESS
Spurious error on select: complains about date format
Keith McMillan
2006-09-15 11:59:07
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
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
>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
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap