SoftVelocity has just released an updated
ODBC driver for accessing TopSpeed (.TPS) data files. This release offers major
enhancements to the supported SQL syntax and conforms to the ODBC 1
specification with many Level 2 features. The TopSpeed ODBC driver allows you
and your customers to use popular productivity tools including Crystal Reports
and Microsoft Excel to connect to TopSpeed databases.
What else can the new driver do? Well, in
addition to making your Clarion applications play nice with other software tools
like the Microsoft Office suite, it can make your development a bit easier and
your applications more flexible.Want more technical details? The new driver
supports the ODBC Level 2 API (most of it). It has support for the SQL
statements: GROUP BY, HAVING, AVG, COUNT, MAX, MIN, SUM. It supports left outer
joins, nested sub-selects, scrollable cursors, multilevel outer joins and scalar
functions.
Enhancements in version 5.0
Version 5 delivers new functionality and
improvements in key areas.
Release 5.0 features improvements in
performance and more reliable connectivity with external tools such as .
Microsoft Data Transformation Service (DTS), Microsoft Access and Excel. Version
5 is also compatible with the ADOdb Database Abstraction Library for
PHP.
- SQLStatistics now returns information
for all keys and indexes, not just the primary key
- Driver improved performance when
working wih large Strings and Decimals
- Wild cards can be used in the
Extensions configuration option
- MS Access sends invalid information to
SQLColumns if a table name has an _ character in it, the driver now detects
this invalid information and transforms it into what Access should have
passed
- Catalog functions will accept table
names that are in quotes
- Added "Use '_' as seperator for the
extension" option to work around bug in Access / DTS where it cannot handle
tables that have a . or /& in them
- ULONG fields can be treated as DATE or
TIME fields
- Improved performance when reading MEMO
and BLOB fields
- The driver supports the szTableType
parameter of SQLTables
- The driver returns the correct scale
of a decimal field even if the field definition is less than 0.1
- The driver returns results for
DISTINCT of more than one column in the SELECT list
- A File level DSN that points at a single file used to refer
to that file as UNNAMED. You can
now refer to the file as UNNAMED or by the physical file
name
Enhancements in verison 4.0
- More efficient threading system based
on the Clarion 6 core
- Improved support for SQL syntax
- INNER is now optional and assumed if
you just do JOIN. This conforms to the SQL 92 spec
- Added support for JOIN syntax without
the {oj}
- Increased the 255 character limit on
string literals to 15000
- BLOBs over 16 mb can now be stored and
accessed
- Updated to work with office XP
- Improvement: SQLTables returns the
list of table, catalog, or schema names, and table types, referenced by the
data source. The driver now handles special cases of mixed superfiles and
varied physical file extensions correctly.
Here are some
more details on the supported SQL syntax.
