Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
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
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

HXTT DBF
support needed on DBF v.3.0 library
Vadym Osadchuk
2006-12-06 13:14:26.0
We recently purchase your library and have come across a bug in the querying mechanism. We are trying to query for a specific key and the values are not being returned properly when using ��=�� operand. We do a similar query using ��LIKE�� and the result is returned. I have attached a small java program that queries the included dbf file both ways and outputs the result. As you will see from this program the results are not showing when using ��=�� but are showing when using ��LIKE��

Class.forName("com.hxtt.sql.dbf.DBFDriver");
Connection conn=DriverManager.getConnection("jdbc:dbf:/dbf");
PreparedStatement ps0;
//=
ps0=conn.prepareStatement("select key from FF where key=?");
ps0.setString(1,"ZR4143466 AW");
System.out.println("==");
ResultSet rs=ps0.executeQuery();
while(rs.next()){
String kkk=rs.getString(1);
System.out.println(kkk);
}
//like
System.out.println("Like");
ps0=conn.prepareStatement("select key from FF where key like ?");
ps0.setString(1,"%ZR4143466 AW%");
rs=ps0.executeQuery();
while(rs.next()){
String kkk=rs.getString(1);
System.out.println("key='"+kkk+"'");
}


and the result is:
==
Like
key='ZR4143466 AW'


I've tried to send database and java to the 'webmaster@hxtt.com' but got a response:

The e-mail system was unable to deliver the message, but did not report a specific reason. Check the address and try again. If it still fails, contact your system administrator.
< mx3.mail.sohu.net #5.0.0 X-Postfix; User "webmaster@hxtt.com" has used up his quota.>


please help us. It's very urgent
Re:support needed on DBF v.3.0 library
HXTT Support
2006-12-06 18:07:39.0
You can send it to webmaster.hxtt@gmail.com
Re:Re:support needed on DBF v.3.0 library
HXTT Support
2006-12-06 18:10:14.0
Try
select LENGTH(key),key from FF where key like ?");

Maybe there're some space characters before 'ZR4143466 AW' values.
Re:Re:Re:support needed on DBF v.3.0 library
Vadym Osadchuk
2006-12-07 07:50:13.0
I sent it to webmaster.hxtt@gmail.com

and the result for "select LENGTH(key),key from FF where key like ?");"
is 14 = strlen("ZR4143466 AW")
Re:Re:Re:Re:support needed on DBF v.3.0 library
HXTT Support
2006-12-07 07:59:15.0
>is 14 = strlen("ZR4143466 AW")
It should be 12:) It means that maybe 2 extra space characters are here, and you can
try
update FF set key ='ZR4143466 AW' where key like '%ZR4143466 AW%';
Or
update FF set key ='ZR4143466 AW' where ALLTRIM(key)='ZR4143466 AW';

Then
your sql should be normal.
Re:Re:Re:Re:Re:support needed on DBF v.3.0 library
Vadym Osadchuk
2006-12-07 08:01:49.0
no, 14 is correct:
ZR4143466 - 9 chars
3 spaces between ZR4143466 and AW
AW - 2 chars

total=14 chars
Re:Re:Re:Re:Re:Re:support needed on DBF v.3.0 library
HXTT Support
2006-12-07 08:11:31.0
Then you can try to run
reindex all on FF;
to avoid the possible invalid index, and see whether your "select key from FF where key=?"); " sql can be normal.

If failed, you can try to download the latest package to test. Otherwise, you need to zip and email your sample to webmaster.hxtt@gmail.com .
Re:Re:Re:Re:Re:Re:Re:support needed on DBF v.3.0 library
Vadym Osadchuk
2006-12-07 08:40:15.0
>>eindex all on FF;
>>to avoid the possible invalid index, and see whether your "select key from FF where key=?"); " sql can be normal.

same result

>>If failed, you can try to download the latest package to test. Otherwise, you need to zip and email your sample to webmaster.hxtt@gmail.com .

did it 30 min ago. please check e-mail

Thanks.
Re:Re:Re:Re:Re:Re:Re:Re:support needed on DBF v.3.0 library
HXTT Support
2006-12-07 18:12:29.0
Recurred issue and Passed test:)
It's an issue which resulted by invalid index information. KEY column is an index column in FF.MDX file.
After run once "reindex all on ff;", your query will become normal.

Re:Re:Re:Re:Re:Re:Re:Re:support needed on DBF v.3.0 library
Vadym Osadchuk
2006-12-08 07:17:00.0
>>It's an issue which resulted by invalid index information.
what's wrong with index?
Re:Re:Re:Re:Re:Re:Re:Re:support needed on DBF v.3.0 library
Vadym Osadchuk
2006-12-08 07:19:23.0
>>It's an issue which resulted by invalid index information.
what's wrong with index?
Re:Re:Re:Re:Re:Re:Re:Re:support needed on DBF v.3.0 library
HXTT Support
2006-12-08 07:21:11.0
>what's wrong with index?
The index information for 'ZR4143466 AW' should be invalid. After run once "reindex all on ff;" to rebuild FF.MDX, your query will become normal.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap