Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
  HXTT Excel v6.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
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 Excel
HXTT Excel (Trial Version) Returns Only First Column
Mark Rizzuto
2013-04-10 13:12:34
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
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
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
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
 

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