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.
|