Clarion ODBC Driver - 5 User Upgrade (s/n & end user details req'd)

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 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