support needed on DBF v.3.0 library |
Vadym Osadchuk |
2006-12-06 13:14:26 |
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 |
|
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 |
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 |
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 |
>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 |
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 |
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 |
>>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 |
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 |
>>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 |
>>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 |
>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.
|
Main
webmaster@hxtt.com