Is GroupBy clause works with HXTT Excel? |
Rama |
2007-11-23 03:36:13 |
Hi All,
I have bought HXTT Excel Driver.I need a small help. My requirement is to group the data. Can the groupby clause work with HXTT Excel? . If it works please provide the syntax.
username:allenjesson@bigpond.com
please help me how i can resolve it.
Thanking you in advance.
Regards,
Rama.
|
Re:Is GroupBy clause works with HXTT Excel? |
HXTT Support |
2007-11-23 03:49:01 |
Supports. It's listed at Select syntax.
|
Re:Re:Is GroupBy clause works with HXTT Excel? |
Rama |
2007-11-23 04:17:42 |
Hi all,
sorry to say that i have seen but the query is not able to retrieve all the data eventhough it satisfies the condition. even with distinct clause also i am getting only partial data.I have posted in the technical support but i didnot get any response. I dont know the reason. please help me in resolving this. It is very urgent.
Here is my query.
select TrackId from sheet1 GROUP BY AdGroup.
Thanking you in advance,
username:allenjesson@bigpond.com
Regards,
Rama.
|
Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
HXTT Support |
2007-11-23 05:10:20 |
>I have posted in the technical support but i didnot get any response.
Sorry. It seems that we missed your question.
|
Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
HXTT Support |
2007-11-23 05:15:13 |
>select TrackId from sheet1 GROUP BY AdGroup.
>even with distinct clause also i am getting only partial data.
It's supported by HXTT Excel. What's your issue? You can email us a xls sample so that we can check it.
|
Re:Re:Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
Rama |
2007-11-23 20:58:15 |
Hi All,
Thanks for your support.i have sent the .xls in zip format to the email address webmaster@hxtt.com.
please refer to it.its very urgent.
Thanks In Advance.
Regards,
Rama
|
Re:Re:Re:Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
HXTT Support |
2007-11-25 05:03:28 |
|
Supported. Please download the latest package.
|
Re:Re:Re:Re:Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
rama |
2007-11-25 21:17:26 |
Hi All,
Sorry to say that i have downloaded the latest Excel JDBC 3.0 Package file but there is no difference between the latest one and previous one. i am very disappointed with this.i tryed both DISTINCT and GROUPBY clauses both are not working or i have to dowload another jar please guide me on this issue.
Regards,
Rama
|
Re:Re:Re:Re:Re:Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
HXTT Support |
2007-11-25 21:31:34 |
>Sorry to say that i have downloaded the latest Excel JDBC 3.0 Package file
You download v1.1.075 on 2007-09-28, but its' v2.0.008 now:) Please login and download:)
|
Re:Re:Re:Re:Re:Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
Rama |
2007-11-25 22:16:12 |
Hi All,
Thanks for your response.But in the files list of download page i am seeing only the files with names Excel JDBC 3.0 and Excel JDBC 2.0 etc....
how would i know that whether it is v1.1.075 or v2.0.008.
please guide me on this issue.
Thanks in advance.
Regards,
Rama
|
Re:Re:Re:Re:Re:Re:Re:Re:Is GroupBy clause works with HXTT Excel? |
HXTT Support |
2007-11-25 22:22:51 |
>i am seeing only the files with names Excel JDBC 3.0 and Excel JDBC 2.0 etc....
Because we provide the latest package with JDBC3.0, 2.0, and 1.2 support.
>how would i know that whether it is v1.1.075 or v2.0.008.
java -cp ./Excel_JDBC30.jar com.hxtt.sql.excel.ExcelDriver .
|
Main
webmaster@hxtt.com