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
Index Problem DBFCDX/8009
Steven Gramsch
2013-10-09 02:17:00.0
Hello,

After an update to a DBF file, the index is adjusted.
However, if I want to work in the dBase tool always comes DBFCDX/8009 file error. When I work on my old tool reorganize this table everything works again.How Can I initiate using the JDBC driver, which he executes the index on the entire table? or is there another possibility?
Re:Index Problem DBFCDX/8009
HXTT Support
2013-10-09 03:37:49.0
First, backup your table file, then run once "reindex all on yourTable" through HXTT DBF, then check whether your dBase tool can read it normally. If failed, you can use lockType=Alaska connection property, then run once "reindex all on yourTable" through HXTT DBF, then check whether your dBase tool can read it normally. If failed still, you should use your dBase tool to reindex your table file, then email us your databases file sample.
Re:Re:Index Problem DBFCDX/8009
Steven Gramsch
2013-10-09 03:54:20.0
where exactly should I use the locktype?

jdbc: dbf :/ / / / / path / CharSet = cp850?
Re:Re:Re:Index Problem DBFCDX/8009
HXTT Support
2013-10-09 05:34:38.0
jdbc:dbf:////path?charSet=Cp850;lockType=Alaska
Re:Re:Re:Re:Index Problem DBFCDX/8009
Steven Gramsch
2013-10-09 07:43:19.0
If I use the JDBC URL so eingebe. Can I use the program that uses the dBASE database, this can not create more records. There is always hanging. Are there other versions of the lockType?
Re:Re:Re:Re:Re:Index Problem DBFCDX/8009
HXTT Support
2013-10-09 08:22:17.0
>Can I use the program that uses the dBASE database, this can not create more records. There is always hanging.
You should use lockType=DBASE . It's listed at here.

lockType: To specify a compatible lock for other applications. You can use DBASE, DBASE4BDE, DBASEIII, DBASEIV, CLIPPER, CLIPPER5.3, PowerPlus, Alaska, SoftC, FOXBASE, FOXBASE4UNIX, FOXPRO, FOXPRO4UNIX, FOXPRO4BDE, and VFP.

BTW, if your index file can be read nomally after run ONCE "reindex ...", then you need only the correct lockType connection property to let HXTT DBF and your dBase tool to begin concurrent data modification in future operation.

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