Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v7.1
  HXTT Cobol v5.0
  HXTT DBF v7.1
 
  Buy Now
  Support
  Download
  Document
  FAQ
  HXTT Excel v6.1
  HXTT Json v1.0
  HXTT Paradox v7.1
  HXTT PDF v2.0
  HXTT Text(CSV) v7.1
  HXTT Word v1.1
  HXTT XML v4.0
Offshore Outsourcing
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
   
   
   
Heng Xing Tian Tai Lab of Xi'an City (abbr, HXTT)

HXTT DBF
Index problem
Marcel Sierra
2010-08-11 08:39:57
I am using the 4.0 driver and use a part in foxpro 7.0 and another using Servoy
this driver, at one point the index of one of my tables are corrupt and want to join from foxpro 7.0 will not let me, but let me continue using Servoy, I need to use both, foxpro 7.0 and Servoy
Re:Index problem
HXTT Support
2010-08-11 08:54:21
Try lockType=VFP connection property. For corrupted index, you need to run once "REINDEX ALL on thattable;"
Re:Re:Index problem
Marcel Sierra
2010-08-12 05:26:58
Running reindex is fixed, but the solution does not help me because the idea is that
the index is not corrupt, there is some solution to this?
Re:Re:Re:Index problem
HXTT Support
2010-08-12 06:23:52
Use lockType=VFP connection property in your jdbc url to avoid future corruption.
Re:Re:Re:Re:Index problem
Marcel Sierra
2010-08-12 06:40:33
that option is already set, this error could
be to use the version 4.0?
Re:Re:Re:Re:Re:Index problem
HXTT Support
2010-08-12 06:56:32
v4.2.039 solved a CDX multiuser compatibility issue with VFP, which VFP will produce specific duplicated index information sometimes on mulituser mode.
v4.2.013 fixed a bug on CDX compound format index file, which will sometimes set wrong index node information for specific complicated string index expression on insert operation.

Maybe your older version met that bug.
Re:Re:Re:Re:Re:Re:Index problem
Marcel Sierra
2010-08-12 07:19:07
thank you very much for your information, Was very helpful, the trial version
to download for testing is the 4.2.039?
Re:Re:Re:Re:Re:Re:Re:Index problem
HXTT Support
2010-08-12 07:38:50
>the trial version to download for testing is the 4.2.039?
v4.2.172

Search Key   Search by Last 50 Questions




Google
 

Email: webmaster@hxtt.com
Copyright © 2003-2019 Heng Xing Tian Tai Lab of Xi'an City. | All Rights Reserved. | Privacy | Legal | Refund | Sitemap