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

Under Development


	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!

Custom Development

Custom Development for you - Delphi and C++ Builder!
Experts in Database, Networking, Data Compression and Encryption.
10+ years experience.

Last Releases

02/02/12
EasyTable v.7.00

01/31/12
Single File System v.3.00

01/30/12
CryptoPressStream v.3.00

10/27/11
MsgCommunicator v.5.00

10/19/11
SQLMemTable v.5.00

10/06/11
Accuracer VCL v.6.00 Beta 2 with XE2

04/27/11
MsgCommunicator Database Pack v.1.10

03/30/11
Accuracer ODBC Driver v.4.02

03/23/11
Accuracer VCL v.5.90 is the fastest Delphi C/S database

02/10/11
Accuracer is the best in the SQL test!

02/17/06
EasyTable ODBC Driver v.1.20

12/14/05
Active Query Builder v.1

10/12/04
Accuracer & EasyTable
are the fastest!
Competitive Prices and
Features Comparison

01/28/04
Accuracer CLX v.1.40 for Kylix

Competitive Upgrade

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

Voting

Do you need Lazarus/FreePascal commercial version of our products?

Accuracer

CryptoPressStream

MsgCommunicator

Single File System

SQLMemTable


	Accuracer is fastest!

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


	Custom Development

	Custom Development for you - Delphi and C++ Builder! Experts in Database, Networking, Data Compression and Encryption. 10+ years experience.


	Last Releases

	02/02/12 EasyTable v.7.00 01/31/12 Single File System v.3.00 01/30/12 CryptoPressStream v.3.00 10/27/11 MsgCommunicator v.5.00 10/19/11 SQLMemTable v.5.00 10/06/11 Accuracer VCL v.6.00 Beta 2 with XE2 04/27/11 MsgCommunicator Database Pack v.1.10 03/30/11 Accuracer ODBC Driver v.4.02 03/23/11 Accuracer VCL v.5.90 is the fastest Delphi C/S database 02/10/11 Accuracer is the best in the SQL test! 02/17/06 EasyTable ODBC Driver v.1.20 12/14/05 Active Query Builder v.1 10/12/04 Accuracer & EasyTable are the fastest! Competitive Prices and Features Comparison 01/28/04 Accuracer CLX v.1.40 for Kylix


	Competitive Upgrade

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