/sqlite-x

Native SQLite access for Clarion

OtherNOASSERTION

Native SQLite access for Clarion

SQLite-x advantage vs FILE,DRIVER('sqlite')

  • Old Clarion versions (C6,C7,C8) supported. SQLite driver was introduced only in C9.
  • ClaLIT.dll not required for distribution.
  • SQL access to non-SQL data (for example, TPS).
  • No need to declare dummy table to obtain SQL query results.
  • Prepared statements supported.
  • Progress of query execution.
  • SQL query result may be immediately stored in a variable, a group, a queue, or a table.
  • Export to CSV (file or clipboard).
  • You can apply SQL filter in standard Browse template, even against non-SQL data.
    For example, in a browse by TPS table you can apply such filter
"WHERE person.Lastname LIKE 'c%' AND division.Number IN (3, 5)" 
  • Arbitrary SQL queries support.
  • UTF-8 support.

Download the demo
If you are not able to download from the link above, drop me private message and I will send you a zip.

Requirements

  • C6 and higher, ABC/Legacy
  • source code only

Dependencies

  • sqlite3.dll

Contacts

Buy now