Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  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 Excel
HXTT Excel (Trial Version) Returns Only First Column
Mark Rizzuto
2013-04-10 13:12:34.0
Hello HXTT,

We are doing a proof-of-concept of HXTT Excel (Trial Version) using Visual Composer and on SAP NetWeaver CE 7.11.

When we run a "select *" query against a sample Excel file, only data from the first column of the table is returned, even though there are multiple columns in the table.

We are aware that the trial version limits the result set to 100 lines. Does the trial version also have a limit regarding the number of columns that can be returned?

What would explain the problem we are having in not being able to read more than a single column in our Excel database table?

Thank you, in advance, for your help.
Re:HXTT Excel (Trial Version) Returns Only First Column
HXTT Support
2013-04-10 17:30:17.0
That issue should not happen. Please email support@hxtt.com your Excel file sample.
Re:Re:HXTT Excel (Trial Version) Returns Only First Column
HXTT Support
2013-04-11 06:34:45.0
No issue. So please check your jdbc setting.

select * from ZCALMONTH_PYG.ZCALMONTHPYG
CALMONTH INTEGER 11 10 0
NBJOUR BIGINT 20 0 0
195001 31
...
215012 31
The total row number of resultset: 2412
Re:Re:Re:HXTT Excel (Trial Version) Returns Only First Column
Mark Rizzuto
2013-04-11 07:55:33.0
Hello HXTT Support,

The issue has been resolved. It would appear that our application is not able to process BIGINT columns. That is why the second column was not appearing in our result sets.

Thank you for your help!

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