TjanSQL 1.1

By JanSoft

Freeware 04 Apr 2002

In category

DB-Aware Components > Direct DB Access > Custom


TjanSQL is a single user relational Database engine implemented as a Delphi object using plain text files with semi-colon seperated data for data storage. Supported SQL: SELECT (with table joins, field aliases and calculated), UPDATE, INSERT (values and sub-select), DELETE, CREATE TABLE, DROP TABLE, ALTER TABLE, CONNECT TO, COMMIT, WHERE (rich bracketed expression), IN (list or sub query), GROUP BY, HAVING, ORDER BY ( ASC, DESC), nested sub queries, statistics (COUNT, SUM, AVG, MAX, MIN), operators (+,-,*,/, and, or, >, >=, <, <=, =, <>, Like), functions (UPPER, LOWER, TRIM, LEFT, MID, RIGHT, LEN, FIX, SOUNDEX, SQR, SQRT). High performance: complete in-memory handling of tables and recordsets; semi-compiled expressions.


  • Status: Fully functional
  • Source: FW
  • Exe demo: included
  • Size: 425 587kB


  • Delphi 4
  • Delphi 5
  • Delphi 6