Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access 7.1.258
  HXTT Cobol 5.0.257
  HXTT DBF 7.1.259
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel 6.1.261
  HXTT Json 1.0.229
  HXTT Paradox 7.1.257
  HXTT PDF 2.0.257
  HXTT Text(CSV) 7.1.257
  HXTT Word 1.1.257
  HXTT XML 4.0.258
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 DBF
HXTT DBF : Column name length
Min Yan GU
2008-08-01 02:17:54
Dear Sir/Madam,

I am the HXTT custmer(user name: ***@***.co.uk) and currently I am using the HXTT DBF to import the FOXPRO Database into Sybase.

My problem is when I try to read the FOXPRO table's column names under linux, the maximum column name length is set to 10 by your package, thus, for the column name "ccredcacc_id" will be read out as "ccredcacc_".

Howerver, I tried to run the program under windows (by using and eclipse and windows console), the table names has been correctly read. So, "ccredcacc_id" is still read out as "ccredcacc_id".

To fix this problem, is there a way for me to set the default column length(maybe to set your properties for the connection)? or if there is not, can you alter your program to support reading column names which their length is large than 10?


Reagrds,
Min
Re:HXTT DBF : Column name length
HXTT Support
2008-08-01 02:41:26
You're using VFP DBC format database, and those long column name information are stored in three files(aDatabaseName.dbc, aDatabaseName.dct, aDatabaseName.dcx).
You should have forgotten to copy three files(aDatabaseName.dbc, aDatabaseName.dct, aDatabaseName.dcx) to your Linux OS.
Re:Re:HXTT DBF : Column name length
Min Yan GU
2008-08-01 02:52:29
Thanks for the message.

However, this does not sounds to be the solution. Because I am running the same copy of program and database on Windows and Linux, and windows it works, but on linux it doesn't take the long column names.

I have checked your documentations, and under the FAQ section, you say:
2. VFP's max column number is 255, and max column name length is 10.
DBF driver supports more than 8000 column, and the max length of clolumn name is 11. The max column size of varchar is 65535. A DB2K table supports at most 32 characters as column name.


I think this causes the problem for linux. How can I alter your max column length value?

Also, I really would like to speak to you, what's the best telephone number I should call?
(I have called all of your coporative office numbers, but no one answers the phone.)
Re:Re:Re:HXTT DBF : Column name length
HXTT Support
2008-08-01 03:04:30
>but on linux it doesn't take the long column names
Please check your Windows directory, you should find *.dbc file, which was missed on your Linux directory.

>I have checked your documentations, and under the FAQ section, you say:
Yeah. But different XBase database format will limite the column name length.
Re:Re:Re:HXTT DBF : Column name length
HXTT Support
2008-08-01 03:06:23
>Also, I really would like to speak to you, what's the best telephone number
> I should call?
Because time zone difference, we provide usually email and web technical support.
HXTT DBF : Column name length
Min Yan GU
2008-08-01 03:09:10
>Because time zone difference, we provide usually email and web technical support.
I can call you.
But can you provide me your telephone number or mobile number?
I am Chinese and I can speak both English and Chinese.
Re:Re:Re:Re:Re:Re:HXTT DBF : Column name length
HXTT Support
2008-08-01 03:12:31
Try 0086 029 88203391. But in fact, you need only to copy the correct three files(aDatabaseName.dbc, aDatabaseName.dct, aDatabaseName.dcx) to your Linux OS.
Re:Re:Re:Re:Re:Re:HXTT DBF : Column name length
HXTT Support
2008-08-01 05:03:03
Supported. Please download the latest DBF_JDBC30.jar . After we have completed test for GROUP BY WITH ROLLUP WITH CUBE, all other version will be updated too.
Re:Re:Re:Re:Re:Re:Re:Re:HXTT DBF : Column name length
Min Yan GU
2008-08-01 05:28:58
Cool, it works now!

Thanks
Re:Re:Re:Re:Re:Re:Re:Re:HXTT DBF : Column name length
HXTT Support
2008-08-01 23:52:37
* v4.1.004 supports WITH ROLLUP, WITH CUBE, and GROUPING(expression).
* v4.1.004 supports bitwise logical operator(&, |, ~, ^, <<, >>), BITAND(x, y), and BIT_COUNT(x).
* v4.1.004 fixed a bug on FPT memo since v4.0.038.

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