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
Simple SQL-Insert could result in some unreadable fields in the MDB file
Norbert
2007-04-13 01:57:39.0
Hello,

we have a problem with some data that is not entered correctly in the mdb file.

Situation: We want to write a CUP file (MDB file with predefined schema). The way we do it is that we generate SQL statements and then run the complete SQL statements into the Access database by using your Access driver.

This seemed to work well, but now we found that in some situations the Access file hold some corrupt data. Opening the file with Microsoft Access shows some incorrect and unreadable fields for some columns of some records. (Most of the data seems to be OK.)

Take for example the two following SQL statements:
insert into Cup_PartUpdateCommodity (Cup_PartUpdateCommodityID, CatLevel1, CatLevel2, CatLevel3, CatLevel4, CatLevel5, CatLevel6, AcctLevel1, AcctLevel2, AcctLevel3, AcctLevel4, AcctLevel5, AcctLevel6) values (2, 'Farming and Fishing and Forestry and Wildlife Machinery and Accessories', 'Agricultural and forestry and landscape machinery and equipment', 'Agricultural machinery for cleaning and sorting and grading', 'Other', '', '', '21', '10', '20', '00', '', '');
insert into Cup_PartUpdateCommodity (Cup_PartUpdateCommodityID, CatLevel1, CatLevel2, CatLevel3, CatLevel4, CatLevel5, CatLevel6, AcctLevel1, AcctLevel2, AcctLevel3, AcctLevel4, AcctLevel5, AcctLevel6) values (3, 'Farming and Fishing and Forestry and Wildlife Machinery and Accessories', 'Agricultural and forestry and landscape machinery and equipment', 'Agricultural machinery for cleaning and sorting and grading', 'Cleaning machines for seed or grain or dried leguminous vegetables', '', '', '21', '10', '20', '01', '', '');

These two SQL statements look similar - only a few fields are different. After importing this data (together with some other additional SQL statements) and opening it with MS Access, then the first record looks OK, but the second record seems to have lost the CatLevel4 field, so that the rest of the fields of this record got shifted one field to the left and the last column 'AcctLevel6' is holding unreadable characters.

When we found the problem, we downloaded the latest available build - which was version 2.1.007 with the build from 2007-01-29. But the problem still exists.

If you need some additional information, then give me a note (and an e-mail address) and I can forward to you our template mdb file and an example SQL file which runs in the problems that I tried to describe above.
Re:Simple SQL-Insert could result in some unreadable fields in the MDB file
HXTT Support
2007-04-13 02:51:26.0
Please email webmaster@hxtt.com your samples. Thanks.
Re:Re:Simple SQL-Insert could result in some unreadable fields in the MDB file
HXTT Support
2007-04-16 03:41:03.0
Haven't received your sample still.
Re:Re:Re:Simple SQL-Insert could result in some unreadable fields in the MDB file
Norbert
2007-04-18 06:41:54.0
Sorry for delay - samples are sent to you a few minutes ago.

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