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
DBF Driver Count Bug
Martin Ross
2006-07-06 08:43:08.0
select ACCNO,SERVCO,count(*) from CLAIM
group by ACCNO, SERVCO
having count(*) > 1

returns
ACCNO SERVCO COUNT(*)
61972 C010A 2
68693 C010A 3
81572 Q994A 2
82950 G271A 2
102151 I020A 2
104172 I001A 2
107850 A007A 2
115872 I001A 2
122940 I008A 2


But
select * from CLAIM
where ACCNO = 61972

ACCNO SERVCO
61972 C010A

returns 1 row!

This isn't correct!

Re:DBF Driver Count Bug
HXTT Support
2006-07-06 09:18:29.0
Failed to recur your issue. I guess that you should have an index on ACCNO. Please try:
REINDEX ALL on CLAIM.
Then you should get the correct result.
Re:Re:DBF Driver Count Bug
Martin Ross
2006-07-06 09:36:00.0
Reindex all makes no difference.

Bug still exists...
Re:Re:Re:DBF Driver Count Bug
HXTT Support
2006-07-06 17:32:51.0
If possible, zip it and email it to our mailbox.

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