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

• mikeduglas@yandex.ru
• mikeduglas66@gmail.com

Buy now