What's new in version 2.1?

• C++ Builder compatible components and examples.
• New licencing policy allowing to buy components for selected protocols.
• Changes in setup program for clean installation of components and examples for selected protocols.
• Added UCP protocol authorization based on OT-60 operation.
• Added ability to set an alphanumeric signature (originator) in UCP protocol (all protocols are now fully alphanumeric originator enabled).
• Added UCP protocol KeepAliveOperation property.
• UCP protocol examples changed to reflect changes in the protocol implementation.

Product description

SMSC Relay VCL SDK library is a set of optimized VCL components enabling quick creation of applications implementing the communication with the SMSC through TCP/IP protocol. The components are created so as to give the widest range of features of the communication with the SMSC and the highest possible efficiency and simplicity of implementation. Implementation of components in VCL technology allows them be used in wide range of Borland programming environments.

It consists of four components. Each of them implements one communication protocol. The set of functions and functionality that are made accessible by components are unified between protocols, and consequently the process of creating applications is simplified to a maximum. Multithreading implementation of components ensures achievement of maximum possible efficiency of sending and receiving messages in communication with the SMSC.

Key features

• Multithreading construction ensures maximum efficiency of the sending and receiving messages process
• Receiving messages sent by users to special (short) numbers (contests, surveys, voting services etc.)
• Possibility to send and receive SMS and EMS messages, messages containing images, animations, logos, sounds etc.
• Possibility to send and receive seven-bit text messages, eight-bit messages with binary data as well as text messages encoded in Unicode (UCS2) standard
• Full information about the message delivery status
• Support for messages containing user header (UDH) and for encrypted messages
• Possibility to send messages in Direct Display mode (FlashSMS)
• Possibility to attach an alphanumeric signature to messages
• Network connection keep-alive functionality
• Tested in cooperation with many SMSC configurations

Supported protocols

• SEMA OIS version 8.1 (Sema Telecoms)
• CIMD2 version 1.2 (NOKIA)
• UCP version 2 (CMG Wireless Data Solutions)
• SMPP version 3.4 (SMPP Developers Forum)

Sample programs

A set of sample programs with the full source code, created for many popular programming environments, is attached to the library. Sample programs demonstrate the use of all functions, events and properties implemented by components.

Currently there are examples of use of the components prepared for the following environments and programming languages:

• Borland Delphi 6 (examples for SEMA, CIMD2, UCP, SMPP)
• Borland Delphi 7 (examples for SEMA, CIMD2, UCP, SMPP)
• Borland C++ Builder 6 (examples for SEMA, CIMD2, UCP, SMPP)

Absolute Database: Delphi database with SQL support.

Absolute Database lets you forget the Borland Database Engine (BDE). This BDE replacement is the compact, high-speed, robust and easy-to-use database engine. With Absolute Database you will not need special installation and configuration, it compiles right into your EXE. Make your application faster and smaller with Absolute Database BDE alternative!

Absolute Database is now single-user database system. Multi-user edition is scheduled to be released in January 2004.

An individual can use Absolute Database Personal in a project if he / she is the only user of this project. If your project is public or if you are a company, you must order commercial version of Absolute Database.

Key Features:

• No BDE; no DLLs
• SQL'92 (DDL & DML) support
• Single database file
• Unmatched ease-of-use
• 100% compatibility with standard DB-aware controls
• Strong encryption
• BLOB compression
• Full source code available
• Royalty-free
• Free for personal use

• No BDE, no DLLs
• No special installation or configuration required
• Database engine compiles right into EXE
• Single-file database format

• Advanced cache management and buffering architecture
• Sophisticated SQL query and filter optimizer
• Special optimized database engine for temporary results of SQL queries
• Fast B*-Tree indexes with high-speed on thousands and on millions of records
• Buffered transactions for batch inserts, updates and deletes
• Optimization for read-only databases, such as databases on CD

• SELECT with DISTINCT, INNER LEFT, RIGTH, FULL and OUTER JOIN, GROUP BY and ORDER BY clauses
• CREATE TABLE, DROP TABLE, ALTER TABLE statements
• CREATE INDEX, DROP INDEX statements
• INSERT, UPDATE, DELETE statements
• BETWEEN, IN, LIKE, IS NULL operators
• Aggregate functions COUNT,SUM,MIN,MAX,AVG
• Most of all SQL'92 arithmetic, logical, date-time and string functions and operators
• Data types conversion by function CAST
• SQL scripts (multiple commands separated by ';')
• Parameters in queries

• Small size of code added into the application by the database engine units
• Small database file size achieved by customizable page size, compression of table metadata and other special means
• Fast BLOB data compression
• Short indexes for string fields
• Low memory consumption

• Support of most of TTable field data types, including BLOB fields
• Full compatibility with standard DB-aware visual controls such as QuickReport, DBGrid, DBNavigator, DBImage, DBMemo, DBRichEdit and others
• Calculated and lookup fields
• Most of TTable functions including Key and Range methods

• Unicode support in String and Memo fields
• Multiple-fields indexes with descending, ascending, case-sensitive and insensitive options
• Shareable tables
• Default values support.
• Min, max and not null constraints on field values

• Strong encryption of database file
• Variety of supported encryption algorithms: Rijndael, the Advanced Encryption Standard (AES) winner 128 bit key, Rijndael 256 bit key, Blowfish 448 bit key, Twofish 128 bit key, Twofish 256 bit key, Square, Single DES and Triple DES

• Repair database in case of hardware failure or operating system error caused by another application
• Auto-detect of database corruption and automatic repair of database file

• Table restructuring being performed in the easiest way keeping all the existing data
• Data importing from and exporting to any dataset
• Internationalization / localization support by use of current system locale
• Displaying progress during potentially slow operations with the tables and databases

• DBTransfer utility to transfer your existing tables from database systems with BDE driver, such as Paradox, Interbase, Access, Oracle, SQL Server to Absolute Database format and vice versa.
• Absolute Database Manager to manage a database easily and to perform all supported operations with tables and database file
• Absolute Database Manager also provides you an easy way of executing SQL queries
• All utilities come with full source code and can be used as an advanced examples

• Full compatibility with TTable, TQuery and TDatabase components
• Extensive documentation: Developer's Guide and Reference covering every development issue.
• Large number of demos illustrating wide range of use cases
• Prompt and responsive technical support

• 100% royalty-free, i.e. there is no additional licensing fees no matter how many times you deploy the application
• Flexible licensing: source code and no source code versions, multi-developers licenses