Accuracer: The First And Only Cross-Platform BDE Replacement
Client-Server Single-File Embedded Database with SQL for Delphi / C++Builder / Kylix
TACRQuery encapsulates a dataset with a result set that is based on an SQL statement.
Use TACRQuery to access one or more tables in a database using SQL statements.
Query components are useful because they can
|·||Access more than one table at a time (called a "join" in SQL).
You can run SQL Scripts by TACRQuery component - just assign script text to SQL property of TACRQuery.
|·||Automatically access a subset of rows and columns in its underlying table(s), rather than always returning all rows and columns.
SQL commands should be separated by semi-colon ( ; ).