rad studio

Fast and simple database app development and deployment to Linux in RAD Studio

The Devart company released UniDAC with support for Linux 64-bit platform. UniDAC makes application development and maintenance easier and simpler because the use of the Direct mode (more…)

Developing applications with Salesforce CRM integration in Delphi

Cloud-based CRM systems are becoming incredibly popular in these days. This trend is quite clear. The usage of cloud services does not require a deployment and costly specialized software domestic support, which ultimately reduces a company’s total expenses. (more…)

Use VirtualDataSet to access objects list via TDataSet interface

TVirtualDataSet is a virtual dataset that can be used as an intermediate between data stored in an application and data-aware controls used in forms. TVirtualDataSet behaves the same way as any other TDataSet (more…)

How to combine data from several sources using SQL and VirtualQuery

The VirtualQuery component allows to perform SQL queries to sources, that are not a database, but a TDataSet or any its descendant. It also allows to connect to several data sources at a time and work with them using SQL queries as with a single data source. (more…)

Using Batch Updates in Delphi Data Access Components

Data amount processed by modern databases grows steadily. In this regard, there is an acute problem – database performance. Insert, Update and Delete operations have to be performed as fast as possible. Therefore Devart provides several solutions to speed up processing of huge amounts of data. So, for example, insertion of a large portion of data to a DB is supported in the Loader. Unfortunately, Loader allows to insert data only – it can’t be used for updating and deleting data.

The new version of Devart Delphi Data Access Components introduces the new mechanism for large data processing — Batch Operations. The point is that just one parametrized Modify SQL query is executed. The plurality of changes is due to the fact that parameters of such a query will be not single values, but a full array of values. Such approach increases the speed of data operations dramatically. Moreover, in contrast to using Loader, Batch operations can be used not only for insertion, but for modification and deletion as well.

(more…)

Disabling Direct Mode In LiteDAC and UniDAC

LiteDAC and UniDAC interact with SQLite in 2 approaches. The first approach is that an application uses functions of the linked SQLite library. For Windows OS it is sqlite3.dll, for Mac OS and iOS – libsqlite3.dylib, for Android – libsqlite.so. The second approach allows to connect to the database from the application directly, using so called Direct Mode. Direct Mode provides interaction with SQLite avoiding any external libraries linking. It is implemented by embedding the code of the SQLite library directly to the application. This approach allows to work with SQLite in cases, when using third-party libraries is impossible due to a number of reasons. For example, when developing applications for iOS or Mac OS, the Apple corporation prohibits deployment of any libraries along with the application.

However, there are situations, when it is preferably to use the first mode. Thus, when developing applications for Android, there is no need to worry about SQLite client library presence, since it is included into this OS distribution. On the other hand, during project implementation, strict requirements may be imposed on the compiled application size. Such requirements are especially relevant for mobile development. Therefore, it is highly desirable to have an opportunity to disable modules, that won’t be used in the application, before compilation. LiteDAC and UniDAC allow to exclude the code of the SQLite client library, that implements Direct Mode, from a ready application. As a result, the size of the developed application may be decreased. (more…)

Resolving RAD Studio XE7 Update 1 and RAD Studio XE8 Installation Crash

Since RAD Studio XE7 Update 1 was released, the ETTracker.dll library was added to installation. Its purpose is obscure, but its presence in the installation caused serious problems for Windows XP users when installing RAD Studio XE7 Update 1. (more…)

Connecting to SQL Server from Android and iOS in Direct Mode Using SDAC

Using SDAC in Direct Mode for access to SQL Server from iOS and Android platforms doesn’t significantly differ from the one on Mac OS X or Windows platforms. Let’s see how this works in a sample below for RAD Studio XE7. (more…)

Connecting to SQL Server from Mac OS X in Direct Mode Using SDAC

Devart Company released SDAC and UniDAC for RAD Studio with a new functionality – Direct Mode for connection to SQL Server. The existing providers for SQL Server by Microsoft use the OLE DB interface, that allows using client applications only on Windows platforms. Due to absence of native solutions by Microsoft for Mac OS X, SDAC Direct Mode was the only opportunity to support SQL Server for Mac OS X.

Devart provides a ready solution for work with SQL Server from Mac OS X – Direct Mode. Let’s consider a simple sample of using Direct Mode. (more…)

ODAC Integration With dbForge Studio for Oracle

Database application development is usually divided into two stages: database design and application writing. Oracle Data Access Components for Delphi (ODAC) allow implementation of work with Oracle server, and dbForge Studio for Oracle – database design and administration. Now, for convenient development, integration with dbForge Studio for Oracle is implemented in ODAC.

To enable integration to dbForge Studio for Oracle, in the Delphi main menu select ODAC → Database Tools → dbForge Studio for Oracle Integration.

(more…)