VCL

Kylix

Download

Technologies

Articles

Products –> VCL


	Products
Delphi Components

Accuracer

EasyTable

SQLMemTable

Single File System

CryptoPressStream

MsgCommunicator

Active Query Builder

Database Master

BDE Replacement

Delphi Database

Kylix Components

Download

Technologies

Articles


	Order
How To Buy

Sales Policy

Upgrade Policy


	Support
Support Policy

FAQ

Contact Us


	Info
Main

News

Why Choose Us

Testimonials

Partners

About Us

Awards

Trademarks

Subscription

SQLMemTable: New capabilities in v.5

New SQL engine.
Stored functions and procedures.
Views are fully supported (with Check option).
CREATE VIEW, DROP VIEW SQL statements added.
CreateView and DropView methods added to TACRDatabase.
Database designer in design time package (double click TSQLMemDatabase).
SQL designer for TSQLMemQuery (double-click in IDE).
New editor for SQL property of TACRQuery supports loading / saving Unicode SQL scripts in all IDE versions.
Table comments support.
Comment property in TACRTable.
COMMENT option in CREATE TABLE and ALTER TABLE.
Unicode support has been enhanced.
Rad Stuido XE2 is supported.

New SQL functionality

New SQL functions added:
ACOS, ASCII, ASIN, ATAN, ATAN2, CHR, CONCAT, COS, COT, EXP, LN, LOG, LOG10, PI, REPEAT, REPLACE, SIN, STDDEV, SQR, SQRT, TAN, COALESCE, DATEADD, DATEDIFF, CUMSUM, CUMPROD, GROUP_CONCAT.
New SQL data types supported:
GUID and NUMERIC (DECIMAL).
Correlated subqueries in SELECT, UPDATE and DELETE statements.
ANY / SOME and ALL operators implemented for SQL statements with subqueries.
CREATE VIEW and DROP VIEW statements added to support Views.
DIV synonym of the division operator added - same as /.
CONSTRAINT keyword is now supported in DDL statements (NULL, NOT NULL, FOREIGN KEY).
Functions ISOWEEK, WEEK and DAYOFYEAR added, as well as corresponding operators of EXTRACT function.
COMMIT SQL command parsing was changed.
EMPTY TABLE command added.
IF EXISTS predicate added to DROP TABLE, EMPTY TABLE.
IF NOT EXISTS predicate added to CREATE TABLE.
BOTH, LEADING, TRAILING support added to TRIM function.
CAST operator extended - now it supports size restriction on string data types, like Char(20).
IFNULL function implemented as synonym of COALESCE. Thus you can use it with any number of expressions.
NULLIF function added.
GET TABLES [Field Number] or SELECT * FROM [DatabaseName.]TABLES ORDER BY [Field Name]
Returns read-only table with descriptions of all tables in the database.
COMMENT option in CREATE TABLE and ALTER TABLE for table comments support.
CASE operator added.
New SQL statements and features to support stored functions and procedures:
- CREATE, DROP, ALTER and EXECUTE functions;
- IF ... THEN ... ELSE ... command;
- BEGIN ... END command blocks;
- Operator := (Assign variable with expression value);
- Session variables - @VariableName.

Stored functions and procedures

New SQL statements and features.
New methods in TACRDatabase:
- CreateStoredFunction;
- DropStoredFunction;
- AlterStoredFunction;
- AlterStoredFunctionRename;
- ExecuteStoredFunction;
- FindStoredFunction;
- GetStoredFunctions;
- ExportStoredFunctionsToSQL;
- IsStoredFunctionManagerExists.

Enhanced Unicode support

SQL property of TACRQuery is now Unicode - TACRWideStringList class.
Can be used in all supported IDE versions.
TACRDataset.Filter property also supports Unicode strings in Delphi 2009 and higher.
TableName property of TACRTable is now Unicode - TACRWideStringList class.
GetTableList of TACRDatabase and GetTableNames of TACRSession now uses TACRWideStringList instead of TStringList.
All export to SQL methods returns WideString instead of AnsiString.
New editor for SQL property of TACRQuery - uses TACRWideStringList class.
Supports loading / saving Unicode SQL scripts in all IDE versions.

Accuracer is fastest!

Accuracer Database System is the fastest Delphi client/server database!

Discounted Giftcards

DigiCounted is a marketplace for buying and selling discounted digital products.

Last Releases

03/27/23
Accuracer VCL v.21.00 for RAD Studio 11.3 Alexandria

03/27/23
SQLMemTable v.20.00 for RAD Studio 11.3 Alexandria

03/27/23
EasyTable v.20.00 for RAD Studio 11.3 Alexandria

03/27/23
CryptoPressStream v.18.00 for RAD Studio 11.3 Alexandria

03/27/23
Single File System v.17.00 for RAD Studio 11.3 Alexandria

03/27/23
MsgCommunicator v.18.00 for RAD Studio 11.3 Alexandria

Competitive Upgrade

If you own a competing product, you may take a discount up to 50%.
Please, contact our

Voting

In what language do you prefer to read a documentation?

English

German

French

Italian

Spanish

Portuguese

Russian

Turkish

Chinese

Japanese

Other:


	Accuracer is fastest!

	Accuracer Database System is the fastest Delphi client/server database!


	Discounted Giftcards

	DigiCounted is a marketplace for buying and selling discounted digital products.


	Last Releases

	03/27/23 Accuracer VCL v.21.00 for RAD Studio 11.3 Alexandria 03/27/23 SQLMemTable v.20.00 for RAD Studio 11.3 Alexandria 03/27/23 EasyTable v.20.00 for RAD Studio 11.3 Alexandria 03/27/23 CryptoPressStream v.18.00 for RAD Studio 11.3 Alexandria 03/27/23 Single File System v.17.00 for RAD Studio 11.3 Alexandria 03/27/23 MsgCommunicator v.18.00 for RAD Studio 11.3 Alexandria


	Competitive Upgrade

	If you own a competing product, you may take a discount up to 50%. Please, contact our


Contact AidAim		© 2000-2023 AidAim Software
RAD Studio Components \| Delphi Components Download \| Multi User Database \| Client Server Database System \| Embedded SQL Database \| Delphi Embedded Database \| In Memory SQL Database \| Fastest In Memory Database

SQLMemTable: New capabilities in v.5

RAD Studio Components | Delphi Components Download | Multi User Database | Client Server Database System | Embedded SQL Database | Delphi Embedded Database | In Memory SQL Database | Fastest In Memory Database