HXTT Access Questions |
Michael Germann |
2007-01-23 06:56:17 |
Hello
We are evaluating HXTT Access 2.1 and have the
following questions:
1. Does HXTT Access 2.1 run with JRE 1.6.0 ?
2. We had problems to issue sql-select statments
with blanks or special characters in where
clause strings ie.
select x,y,objid from gs_street where street='Am Wasser Weg'
The same select without blanks in where clause
returned with success. We are using Access 97
.mdb files on windows xp. Is this a known problem ?
Thank you for your help.
Regards,
Michael Germann
|
Re:HXTT Access Questions |
HXTT Support |
2007-01-23 07:31:55 |
1.Does HXTT Access 2.1 run with JRE 1.6.0?
Yes.
2. We had problems to issue sql-select statments with blanks or special characters in where clause strings ie.
Please zip your access file and send it to our email box(webmaster@hxtt.com or webmaster@hxtt.net). We will check and fix it.
|
Re:Re:HXTT Access Questions |
HXTT Support |
2007-01-24 19:30:10 |
I guess that you should have an index on street column. Because Access 97 will use different index encoding for different charSet, so we need to check your mdb sample.
|
Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-25 01:49:22 |
Hello
As we had problems to send you the
requested file by email (virus alert),
you can download the requested file
from our webserver:
http://www.infogrips.ch/download/test.zip
Regards,
Michael Germann
|
Re:Re:Re:Re:HXTT Access Questions |
HXTT Support |
2007-01-25 06:32:11 |
Thanks for your sample. Supported. Please download the latest package.
|
Re:Re:Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-25 06:36:03 |
Hello
We downloaded the package yesterday.
Do you say: we have to download it
again (new version) ?
Regards,
Michael Germann
|
Re:Re:Re:Re:Re:Re:HXTT Access Questions |
HXTT Support |
2007-01-25 18:03:43 |
Yeah. You need to redownload.
|
Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-26 00:33:46 |
Hello
Thank you for the fix. Now
blanks are no problem anymore,
but special german characters
(Umlaut) still do not work ie.
'Alte Z������rcherstrasse'
You can find serveral examples
in the test .mdb file.
Regards,
Michael Germann
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
HXTT Support |
2007-01-28 06:04:57 |
>but special german characters (Umlaut) still do not work ie.
Supported. Please download the latest package.
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-29 01:09:29 |
Hello
We downloaded the new version. Now
it somewat better, but still not
perfect. For example
'Alte Z������rcherstrasse' is found
but
'R������tiweg' is not found.
There is still a problem with german
Umlaut characters. Do we have to specify
the characterset by calling some
java function ?
Regards,
Michael Germann
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
HXTT Support |
2007-01-29 02:54:13 |
>'Alte Z������rcherstrasse' is found
>but 'R������tiweg' is not found.
What's your Access 97 local version? What's your sort order for mdb file?
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-29 04:06:43 |
Hello
See the test .mdb at
http://www.infogrips.ch/download/test.zip
It has to be possible to select any
street value (with or without Umlaut or
Blank / special character).
Regards,
Michael Germann
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
HXTT Support |
2007-01-29 04:26:29 |
I download http://www.infogrips.ch/download/test.zip on 25th, and you can remove it to avoid your sensitive information leak. I wonder just what's your Access 97 local version because some index rules for your local language need to be cracked again:)
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-29 05:58:00 |
Hello
We used Access 97 SR-1 german version to
create the database. The database
was filled only by ODBC calls through
the Microsoft Access ODBC driver (not
with Access user interface). I hope this
helps.
Regards,
Michael Germann, infoGrips GmbH
|
Re:HXTT Access Questions |
HXTT Support |
2007-01-29 08:20:34 |
Supported. Thanks.
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-30 02:29:28 |
Hello
You say "supported". Is there a new version
available for download ?
Regards,
Michael Germann
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
HXTT Support |
2007-01-30 03:54:28 |
Yeah.
|
Re:Re:Re:Re:Re:Re:Re:Re:HXTT Access Questions |
Michael Germann |
2007-01-30 04:02:16 |
Hello
Now it works. Thank you very much
for your quick help.
Regards,
Michael Germann
PS: You can keep the test.mdb for
test purposes. This is not
productive data.
|