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
HXTT DBF indexes
Sije de Haan
2010-11-25 04:33:06.0
What is the default index type HXTT DBF uses? CDX or IDX? Which type is created when I perform a 'CREATE INDEX' statement?
Why doesn't the driver respond to the property 'Default Index Suffix'(is this th right property name?)?
If I succeed in providing the 'Default Index Suffix', does it change not only the extension but the type as well?

Re:HXTT DBF indexes
HXTT Support
2010-11-25 05:04:41.0
>What is the default index type HXTT DBF uses? CDX or IDX?
CDX or IDX according to index expression.

>Which type is created when I perform a 'CREATE INDEX' statement?
According to your CREATE INDEX sql, HXTT DBF supports to create any kind of IDX, CDX, MDX, NTX, and NDX if you assign suffix. for instance,
create index user of test.cdx on test (user ASC);
create index int1,char1 of test.cdx on test (int1 unique ,char1+int1 for not empty(char1));
create index if not exists ttt,bbb of product1.cdx on product1 (currency1,mem1 PRIMARY KEY ASC);
create index ttt of user.cdx on user@brian (user ASC);
create index aa of [table].mdx on [table] (char1);
create index ttt of testntx3.ntx on testntx (esercizio)
create index TACCT of cmbbillfile.ntx on cmbbillfile (TACCT);

create index int1 of test.cdx on test (int1 ASC);
create index user of test.cdx on test (user ASC);

>Why doesn't the driver respond to the property 'Default Index Suffix'(is this
> th right property name?)?
>If I succeed in providing the 'Default Index Suffix',
> does it change not only the extension but the type as well?
Yeah. It will change the default type too. Because 'Default Index Suffix' and "Incremental Index" is not preferable connection property so that it contains one space character between words.


Re:HXTT DBF indexes
HXTT Support
2010-11-25 05:06:36.0
BTW, if any XBase application does concurrent modfication, you need lockType connection property to let HXTT DBF and Xbase application can see each other.
Re:Re:Re:HXTT DBF indexes
Sije de Haan
2010-11-29 00:16:37.0
You didn't answer my question why the HXTT DBF driver doesn't seem to act on the 'Default Index Suffix' property, example:
Properties properties = new Properties();
properties.setProperty( "lockType", "VFP" );
properties.setProperty( "Default Index Suffix", "CDX" );
con = DriverManager.getConnection( url, properties );
executeUpdate( "CREATE TABLE customer (ID INTEGER PRIMARY KEY, "
+ "First_Name char(50), Last_Name char(50), Address char(50), "
+ "City char(50), Country char(25), Birth_Date date )" );
I get an IDX file and not even a valid one, the index does not show up when I inspect the table with FoxPro.
Re:Re:Re:Re:HXTT DBF indexes
HXTT Support
2010-12-01 05:24:00.0
Sorry for missed that thread. Checked. Old package will use IDX format when there's only one expression, although "Default Index Suffix"="CDX". The latest package will be available after about 2 hours.

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