Latest feature:

• supoorts MySQL Migration Toolkit

2005-09-12 DBF v2.1 JDBC1.2 Package(764KB) JDBC2.0 Package(778KB) JDBC3.0 Package(802KB)

• supoorts MySQL Migration Toolkit
• supports MS Windows service and Linux Daemon for remote connection and remote control
• supports DISTINCTROW.
• supports XA-Resources
• provides ILIKE syntax support,ignore upper and case like
• provides $ token for checking whether left string is contained in right string.
• provides transaction sql.
• CDX supports Slovak, Greek, Polish, Turkish, and Hungarian collation sequences.
• supports VFP 9.0's BINARY INDEX.
• supports VFP 9.0's Varchar, Varinary, and Blob columns.
• provides automatic temporary index feature option.
• works simultaneously with BDE's DBASE and FOXFRO driver.
• supports Clipper's buffer concurrency check for NTX.
• provides user/password verification for remote access.

2005-01-01 DBF v2.0 JDBC1.2 Package(666KB) JDBC2.0 Package(659KB) JDBC3.0 Package(674KB)

• provides the quicker TCPServer to replace the slow RMIServer.
• utilizes index for ORDER BY and DISTINCT.
• supports CREATE SEQUENCE, DROP SEQUENCE, and ALTER SEQUENCE.
• provides MissingMemoFile properity to ignore or repair when memo file is missing.
• provides Database GUI Manager.
• NTX format is full compatible with DBU's balance tree.
• provides collate function for multilingual sort.
• supports Mazovia charSet.
• supports [reserved word].
• provides MD5 function.
• supports SIx Driver tradition with its .SMT memos.
• supports SIxMemo memo.
• provides Table Encryption and Column Level Encryption.
• provides BINARY, VARBINARY type
• provides _LockFlag_ virtual column as row lock flag for Borland's dataset.
• provides encrypt/decrypt function for Row-Column (Cell) Level Encryption.
• supports lock/unlock record programatically.
• supports Xbase applications' compatible lock on OS2.
• supports Xbase applications' compatible lock on Linux.

2004-04-20 DBF v1.2 JDBC1.2 Package(343KB) JDBC2.0 Package(412KB) JDBC3.0 Package(426KB)

• supports fully ALTER TABLE.
• provides _rowid_ virtual column as primary key for Borland's dataset.
• supports { UNION | INTERSECT | EXCEPT | MINUS } [ ALL ] query operations.
• supports INNER, FULL, LEFT, RIGHT, NATURAL, and CROSS JOIN.
• supports subquery which includes single-row subquery, multirow subquery, multiple-column subquery, inline views, and correlated subquery.
• complements more than 30 sql functions.
• optimizes some OR querys through index file.
• tested DBF JDBC1.2 with Personal Java 3.1.
• supports utilizing index file for LIKE, BETWEEN, and IN operations.
• supports using other default suffix except for table and index file.
• supports selecting based upon the column name defined in the .DBC container.

2003-10-22 DBF v1.1 JDBC1.2 Package(381KB) JDBC2.0 Package(361KB) JDBC3.0 Package(388KB)

• supports Visual dBASE 7's table (DB2K format).
• supports complicated HAVING clause, for instance, select int1 AS a,count(*) b,sum(int1) as c,count(*)+sum(INT1),a+c from test group by a having sum(test.iNT1)>3310 and b>1 or a<-3000
• provides one string operator, || , for string concatenation. Both of + and - for string concatenation are still supported.
• supports function DATABASE(), SYSDATE().
• supports CURRENT_DATE, CURRENT_TIME, and CURRENT_TIMESTAMP keyword.
• supports javax.sql.RowSet.
• supports function IFNULL(expression, value).
• supports java.sql.BLOB and java.sql.CLOB.
• supports function COALESCE(value [, ...]).

2003-06-24 DBF v1.0 JDBC1.2 Package(376KB) JDBC2.0 Package(342KB) JDBC3.0 Package(365KB)

• Development Documentation is available.
• supports JDBC3.0 .
• CDX supports CZECH collation sequence.
• Quicken CREATE INDEX and REINDEX operation
• supports [IF NOT EXISTS] for CREATE SCHEMA, CREATE TABLE, CREATE INDEX. For instance, "CREATE SCHEMA IF NOT EXISTS abc".
• supports [IF EXISTS] for DROP TABLE, DROP INDEX. For instance, "DROP TABLE IF EXISTS test".
• fixed a few known bugs.

2003-05-28 DBF Beta6.6 JDBC1.2 Package(371KB) JDBC2.0 Package(335KB)

• supports DreamWeaver ColdFusion
• supports "ALTER TABLE tbl_name alter_specification [, alter_specification, ...]". Only supports "alter table tbl_name RENAME [COLUMN] column TO newcolumn".
• supports delayed transaction for PreparedStatement.
• provides 2-level cache.
• fixed a few known bugs.

2003-04-26 DBF Beta6.5 JDBC1.2 Package(350KB) JDBC2.0 Package(315KB)

• supports function TRIM([[BOTH | LEADING | TRAILING] [remstr] FROM] str).
• supports using column alias in any expression of SELECT statement.
• supports aggregate function STD(expr) and STDDEV(expr).
• supports function initcap(text), lpad(text,int,text), rpad(text,int,text), LEAST(X,Y,...), and GREATEST(X,Y,...). Now more than 100 sql or Xbase functions have been supported.
• supports function DATE(), DATETIME(), TIME(), CTOD(cExpression) and CTOT(cCharacterExpression).
• supports POSITION(substr,str) function.
• supports EMPTY(eExpression) function.
• quicken RECNO() query.
• supports "CREATE SCHEMA schemaName".
• supports DbEdit Database Utilites for Eclipse Platform.
• supports join query on more than two big databases without memory limitation.
• optimize distinct, group by and order by for join query.
• fixed a few known bugs.

2003-03-02 DBF Beta6.4 JDBC1.2 Package(340KB) JDBC2.0 Package(305KB)

• "update tableName set _DeletedFlag=false[, column-identifier = {expression | NULL}]... [WHERE search-condition]" will unmarks records marked for deletion in the selected table.
• Provided Clipper's function CHARMIRR(cExpression[,lDontMirrorSpaces]) to reverse a string.
• Supported Clipper's DESCEND function.
• Supported Clipper's encrypted header.
• Clipper's CGP file has been supported.
• Provided external sort for DISTINCT, GROUP BY, and ORDER BY clause.
• fixed a few known bugs.

2002-11-21 DBF Beta6.3 JDBC1.2 Package(323KB) JDBC2.0 Package(287KB)

• Provided function VAL(cExpression) to return a numeric value from a character expression composed of numbers.
• Provided function RECCOUNT([nWorkArea | cTableAlias]) to returns the number of records, which includes all deleted records.
• Provided "lockTimeout" property to declare how long in milliseconds DBF driver will wait for other Xbase applications to release record lock.
• Besides VFP lock, the compatible lock of CLIPPER has been tested fully.
• Provided function rowLocked([nWorkArea | cTableAlias]) to indicate whether the current row has been locked by other process or application.
• Supported partly VFP's DBC, DCT, and DCX files. Now you can use "select yourColumn from yourDbc.yourTable".
• Supported ObJectRelationalBridge(OJB).

• old DBF URL format:
          Embedded:
                  jdbc:dbf:[//]/[DatabasePath]
                          For example: "jdbc:dbf:/." "jdbc:dbf:/c:/dbffiles"
                  For unix or linux:(You can't omit that "//" characters)
                          jdbc:dbf:///[DatabasePath]
                                  For example: "jdbc:DBF:////usr/data" "jdbc:DBF:///./data"
          Access by DBF Server: Skip it if you don't use RMI or JINI.
                  jdbc:DBF:[//][host][:port]/[DatabasePath]
              Default host:localhost port:8029 DatabasePath:
              For example: "jdbc:DBF://domain.com:3099/dbffiles" if one DBFServer is run on the 3099 port of domain.com
  
  new DBF URL format:
          Embedded:
                  jdbc:dbf:[//]/[DatabasePath] (You can omit that "//" characters)
                          For example:
                                  "jdbc:dbf:/."
                                  "jdbc:dbf:/c:/dbffiles"
                                  "jdbc:DBF:/./data"
                                  "jdbc:DBF://usr/data" for unix or linux.
                                  "jdbc:DBF:////usr/data" for unix or linux.
          Remote Access:
                  jdbc:DBF://host:port/[DatabasePath]
                          For example:
                                  "jdbc:DBF://domain.com:3099/dbffiles" if one DBFServer is run on the 3099 port of domain.com
          Access A net URL(Uniform Resource Locator, a pointer to a "resource" on the World Wide Web) (You can get a CONCUR_READ_ONLY resultSets. Please don't use that format if your table is too big to donwload.)
                  jdbc:DBF://url (It'll be supported soon.)
                          For example:
                                  "jdbc:DBF://http://www.hxtt.net/jdbc"
  

• fixed a few known bugs.

2002-11-02 DBF Beta6.2 JDBC1.2 Package(279KB) JDBC2.0 Package(269KB)

• supports "INSERT INTO table [(column [, ...])] SELECT query".
• "delete from tableName where deleted()" will pack database.
• supports ASC(cExpression), CHR(nANSICode), and IF(lExpression, eExpression1, eExpression2).
• supports "REINDEX {ALL | indexFileName[,indexfiLEName2,...]} ON table-name".
• Regards CANDIDATE as primary key in DatabaseMemtaData.getPrimaryKey().
• Uses "OtherExtensions" property (Default:false) to indicate whether DBF driver supports other extensions except for '.DBF'.
• Supports "INLIST(eExpression1, eExpression2 [, eExpression3 ...])" function.
• fixed a few known bugs.

2002-10-15 DBF Beta6.1 JDBC1.2 Package(279KB) JDBC2.0 Package(267KB)

• CDX supports RUSSIAN collation sequence.
• DeletesAreVisible property to indicates whether or not the resultSet include deleted records.
• Compatible with DBVisualizer 3.0.
• Changed the schema term from "\" to ".".
• complemented function TTOC(tExpression [, 1 | 2]), TTOD(tExpression), DTOT(dDateExpression), PADL(eExpression, nResultSize [, cPadCharacter]), PADR(eExpression, nResultSize [, cPadCharacter]) , PADC(eExpression, nResultSize [, cPadCharacter]), and STUFF(cExpression, nStartReplacement, nCharactersReplaced, cReplacement).
• "delete from tableName where true" will zap database.
• supports FlexFile3 memo.
• fixed a few known bugs.

2002-08-26 DBF Beta6 JDBC1.2 Package(273KB) JDBC2.0 Package(260KB)

• supports JDBC1.2 and JDK1.1.8.
• supports Xbase applications' compatible lock.
• fixed a few known bugs.

2002-05-06 DBF Beta5.4.1(288KB)

• Join query has supported aggregation function, Group By and Order By.
• fixed a few known bugs.

2002-04-02 DBF Beta5.4(292KB)

• fixed a few known bugs.

2001-11-27 DBF Beta5.3(294KB)

• supports GROUP, BETWEEN and IN.
• work normally with JBuilder 5 Database Pilot and Dreamweaver UltraDev 4.
• fixed a few known bugs.

2001-07-30 DBF Beta5.2(332KB)

• supports DISTINCT and IS.
• fixed a few known bugs.

2001-06-09 DBF Beta5.1(329KB)

• complemented function IIF(lExpression, eExpression1, eExpression2).
• fixed a few known bugs.

2001-03-13 DBF Beta5(337KB)

• supports Multi-user Access.
• complemented function DELETED([cTableAlias | nWorkArea]) and SUBSTR(cExpression, nStartPosition [, nCharactersReturned]).
• fixed a few known bugs.

2000-12-24 DBF Beta4.21(317KB)

• supports Clipper Index files (*.ntx).
• complemented function ALLTRIM(string), DTOC(date) and CHRTRAN(cSearchedExpression, cSearchExpression, cReplacementExpression).
• fixed a few known bugs.

2000-08-04 DBF Beta4.20(306KB)

• supports Multiple Index files (*.mdx).
• complemented XOPEN SQLState.
• complemented PRIMARY KEY for CDX.
• complemented function DTOS(date).
• complemented "INSERT INTO tableName VALUES(value1[,value2,...])"
syntax.
• fixed a few known bugs.

1999-10-08 DBF Beta4.01(259KB)

• enables update operation for uncompressed index files (*.idx).
• fixed a few known bugs.

1999-09-12 DBF Beta4(255KB)

• supports column alias.
• supports derived column.
• supports Statement.setFetchSize(int rows).
• supports catalog and schema.
• complemented most of functions of DatabaseMetaData.
• complemented function LOWER(string) and UPPER(string).
• enables Create Index statement and DROP Index statement for uncompressed index files (*.idx).
• enables partly update operation for uncompressed index files (*.idx).
• fixed a few known bugs.

1999-04-12 DBF Beta3(216KB)

• enables Create Table statement and DROP TABLE statement.
• enables ORDER BY clause.
• supports LIKE Escape Characters.
• complemented function RECNO([nWorkArea | cTableAlias]).

1999-03-08 DBF Beta2.2(226KB)

• supports Jini1.0FCS and JNDI1.1.2 .
• supports VFP's nullable column.
• supports five aggregate functions: AVG, COUNT, SUM, MAX and MIN.
• supports function STR(nExpression [, nLength [, nDecimalPlaces]]).
• fixed a few known bugs.

1999-02-14 DBF Beta2.1(224KB)

• supports scrolling and updatable resultset.
• supports Clipper's DBT file according to one user's requirement.

1999-02-01 DBF Beta2(163KB)

• supports Time and Date Literals.
• supports all scalar Functions in jdbc-spec.frame11.html except DATABASE(), IFNULL(expression, value), USER() and CONVERT(value, SQLtype).
• PreparedStatement to accept and store java objects in General field.
• three kinds of IDX and CDX index files for query.

1999-01-11 DBF Beta1(140KB)

• supports RMI, serialization and unicode character set.
• supports xbase, foxpro and VFP free table.
• supports all kinds of data except general type.
• supported statements include query, delete, update and insert.
• supports complicated expression and two fuctions(max and min).