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
Search on numeric value returns no result
Transer
2010-02-13 09:15:45.0
Hi!
After the fix for support request "Improper result of search byte value in column of character type" search by numeric value in numeric column returns no results. But search on ">" works right.
Test query: "select * from table where field = 1". Result: no rows - wrong.
Test query: "select * from table where field > 0". Result: lot of rows - right.
Table has compound index and tag with same name as field.
Table format: FoxPro 2.5 for DOS, versionNumber - "F5", code page - CP866.
Actual DBF driver was used.
Thanks.
Re:Search on numeric value returns no result
HXTT Support
2010-02-15 22:30:30.0
According to our test, the showed 1 value is stored as 0.9999999987640456 in DBF, which VFP failed to query with CDX too. Please download the latest package which can fix your where clause and query the value between 0.999995 and 1.00005 for you.
Re:Re:Search on numeric value returns no result
Transer
2010-02-16 03:07:56.0
In my case numeric value layed out in DBF as as strings (if open in text editor) in the same format as seen ("1", not "0.9999999987640456"). And driver maps numeric values as BigDecimal. So, IMHO it is necessary to fix bug rised in driver from 2010-01-12 and revert workaround solution with searching between two values (keep in mind performance issues).
Test table was sent to support@hxtt.com.
Re:Re:Re:Search on numeric value returns no result
Transer
2010-02-16 03:19:53.0
Note, field has a type NUMERIC, not FLOAT, with width 2 and decimal positions 0 ("N(2,0)").
Re:Re:Re:Re:Search on numeric value returns no result
HXTT Support
2010-02-16 06:02:38.0
Pass also test your sample with the latest package. Please try.
Re:Re:Re:Re:Re:Search on numeric value returns no result
Transer
2010-02-16 07:04:00.0
Driver DBF 4.2.126 returns proper results. Thanks.

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