Latest Articles

Upgrade SKU to be Discontinued by March 31st

Written by Atanas on . Posted in Support

Dear Customers,


A few years back we introduced our Update Subscription program. This approach to licensing was a response to dominant industry trends to move away from periodic Upgrades to ongoing Subscription relationships that deliver continuous value to customers. Our Product Roadmap and Release Strategy are aligned with this philosophy as we strive to make upgrades to new releases much easier. I don’t think that we will ever be perfect here, but we certainly will try.


We have many long-term passionate customers that are used to a certain way of purchasing our products. Therefore we retained the one-off Upgrades SKU (i.e. Purchase Option) for quite some time. Our experience is that customers love plenty of advanced notice to any changes. Many of you let us know this loud and clear, and we appreciate it.


Our goal is to make it easy for everyone to take advantage of the latest features and fixes we’ve developed. Today, most our customers moved to Update Subscription and the Upgrades SKU simply does not make as much sense. It is unnecessarily complex to maintain and we hear from multiple customers that with some of the more aggressive promotions, it makes purchasing decisions confusing. Pretty much all other vendors have discontinued that SKU for similar reasons.


This Quarter (ending on March 31st) will be the last to offer Upgrades. In keeping with our advance notices practice, we want to give plenty of time to customers who for any reason want to use the Upgrades SKU to do so. We ran several Amnesties (i.e. ability to Upgrade from older versions) in the last couple of years, and we will run one more as we retire this SKU. We will continue to offer easy paths to move to higher Editions, as we make both the Enterprise and Architect editions even more attractive for enterprise application development. It is not a huge change, but nevertheless, we want to minimize surprises. If you have been on the fence about Upgrading your old version, now will be a good time and remember that you get your first year of Update Subscription included.


Together, we made great strides in popularizing RAD Studio for Delphi and C++ development. We carefully monitor competitive offerings and we strongly believe that the value customers receive with our products is far superior to the cost. I hope you feel the same way. We are committed to continue investing in our products to make your ROI calculations a “no-brainer”. I am really excited about some of the upcoming releases. Both 10.2.3, this quarter, and the many releases in the quarters to come, will deliver some awesome functionality and quality improvements. 2018 be another year that sees the momentum of Delphi and C++ Builder increase - Go RAD Studio!!!


As always, feel free to reach out to me any time directly. We love hearing from customers who deeply care about our products.





Cool App Winner for November: InfoTrain

Written by Jim McKeeth on . Posted in Articles

I’m always pleasantly surprised by the variety of projects people come up with using Embarcadero tools, and our November Cool App winner is no exception. InfoTrain -- developed by Damian Skrzek using Delphi -- is an application that helps railway enthusiasts locate and discuss interesting trains.

When users notice interesting trains, they can add detailed information in the app that can be sorted and filtered by various details. “Railfans,” or “trainspotters,” can filter by the type of traction, region, railway line and many other features. Users can comment or update listings by adding photos or timely information about the current location of a train.


InfoTrain connects to a remote MySQL database via a PHP API to synchronize data between users. The app is currently available on all Android devices, with an iPhone version in the works.

InfoTrain is a perfect example of an enthusiast who was able to develop an app that scratches his own specific itch. The great thing is that Damian could then make that app available to all the other people who share his interest. Using a PHP API to connect to a MySQL backend is a creative solution to data sharing and shows the flexibility of Delphi.

When asked about his choice of languages, Damian said “Delphi is a friendly environment for beginners, powerful at the same time for advanced users. Great for creating cross-platform applications. Generally, Delphi is my favorite language.”

This video provides a nice overview of InfoTrain.


Interested in submitting for the Embarcadero’s Cool App contest? It’s open to any business or consumer application built with RAD Studio, Delphi or C++Builder. Embarcadero awards Cool App contest winners a $500 Amazon gift card and winning submissions are also highlighted on the company’s YouTube channel. For more information on the contest and a link to the submission form, click here.

Holiday Delphi To-Dos

Written by Jim McKeeth on . Posted in Articles

Merry Christmas from Godzilla

After another year of record CodeRage participation, I’ve been talking to other developers about what they do to promote Delphi. It was immediately obvious that they are “way too busy writing code!” This is a huge improvement, as only a few years back the standard response was “well, Delphi is no longer cool.” However, we still have a challenge. We need to make it easier for our customers to champion us within their organizations. We want people to be proud to say that they “do Delphi.”


Here are a few Delphi holiday To-Dos if you are looking for a way to spread the merriment...


  1. Check out 10.2.2 with the new dark theme and a whole lot more. It will give you some good hints on where we are going with UX and it is just the beginning. Also, the Enterprise and Architect editions of RAD Studio now gets a RAD Server site license for FREE! A huge benefit! Don’t hesitate to provide feedback - we love it!


  1. Share Delphi @ 22 Magazine with your colleagues and managers to highlight the latest developments with Delphi and our ecosystem… there has been a lot of activity that has been missed. And yes there was some healthy debate on one forum around the number of countries in existence (we counted a huge number in one of our Delphi Boot Camps), but aside from classifications, the point is that we are seeing a resurgence and we like it!


  1. Build a Simple Mobile App with FMX. There is no better way to wow your customers, peers or supervisors than to see Delphi in action. There are plenty of samples and more coming your way. Write once and compile for Android and iOS, not to mention Windows and mac OS X.


  1. Check out the new Enterprise connectors. So simple to display your feed from Twitter and/or Facebook and show how fast you can build an app around it. More complex ideas may want to leverage the free InterBase for embedded mobile use. There are plenty of “disconnected” use cases that are difficult to do with other technologies.


  1. Watch a CodeRage replay on Embarcadero Academy.  Go catch a replay for a session you missed from CodeRage XII. They are all available on Embarcadero Academy. Share your favorite session with your friends. While you are there sign up for a course from the expert trainers on Embarcadero Academy. Also, make sure that if anyone doubts that there are good materials to learn Delphi, they know that this is no longer the case.


  1. Learn about the Ext JS framework. Sencha is new to our developer tools family, but already making a huge impact. There is a lot of tooling in existence to connect Delphi with Ext JS development. They share a lot in their completeness and focus on huge productivity improvements. There is a learning curve, but if you are looking for fast development across platforms with really nice UX, this is the way to go. Delphi and the associated VCL & FMX frameworks share a lot in common with Ext JS in the way they maintain compatibility for the long-run and provide unmatched performance. This sample app provides a great example that speaks both to FMX and Ext JS.


  1. Browse the GetIt Package Manager. Install a new style, sample project, library, or IDE Plugin. GetIt continues to expand: over 250 at last count. Look for new ways to solve the problems you face and make yourself even more productive.


  1. Blog about your favorite Delphi features, components or libraries and share it on social media. Delphi has an amazing 3rd party ecosystem. Check out the top 10 Delphi projects on GitHub or this huge collection of resources.


What’s on your holiday to-do list? Do you have any Delphi goals for the new year?

RAD Android is Our Cool App Winner for October

Written by Jim McKeeth on . Posted in Articles

RAD AndroidI hope everyone had a nice Thanksgiving, and survived the Black Friday/Cyber Monday marketing deluge. I was so busy catching up with family and eating too much that I’m just now announcing Embarcadero’s October Cool App contest winner is RAD Android, an app that makes it easy for people to develop mobile programs.

RAD Android, created by talented developer Abdalkader, is a tiny programming language for the Android operating system that allows anyone to write simple programs for Android devices from an Android device. These apps leverage wireless capabilities such as Bluetooth, SMS and Wi-Fi so people can create a wide variety of useful smartphone tools. They can also communicate with the Arduino open source electronics platform to enable makers and tinkerers of all levels to develop an array of imaginative tools and projects such as digital scientific instruments or home tools like an automatic guitar tuner.

Using Delphi to create an application development solution, even a tiny one, is a significant undertaking. RAD Android is an amazing example of how native development can unlock the power of the Android platform, given a dedicated and talented developer with the right skills and tools for the job. 

This video shows RAD Android in action:

Or visit the Google Play store and install this free app for yourself!
Interested in submitting for the Embarcadero’s Cool App contest? It’s open to any business or consumer application built with RAD Studio, Delphi or C++Builder. Embarcadero awards Cool App contest winners a $500 Amazon gift card and winning submissions are also highlighted on the company’s YouTube channel. For more information on the contest and a link to the submission form, click here.


Server Maintenance and Future Enhancements

Written by Jim McKeeth on . Posted in Articles

Please note that our online Docwiki, Embarcadero Forums, EDN Member Services and some of our support systems are currently not accessible. These systems were taken down for maintenance over the weekend when we identified some additional issues that we are resolving promptly. We apologize for any inconvenience this has caused, and hope to have these systems back online soon.


We wanted to also take this opportunity to talk about some of the planned customer portal enhancements over the next six months. As you are probably aware, our EDN site is quite dated as it has been in use for many years. It has a lot of functionality that we know many customers like, but some that are no longer used extensively. We have started an effort to migrate to more modern platforms, such as the one used by our Community Portal. That initiative has been hugely successful and we want to migrate the rest of the functionality.


Over the coming months, we will start to introduce some of these changes. Some of these are specifically aimed to increase the value for customers on active Update Subscription. We are committed to providing ample communications for any significant changes. For example, Code Central has a long history of downloads. The way we assign these also has made tracking Code Central IDs to specific downloads difficult and resulted in many obsolete IDs. Legacy downloads will likely be folded into a new Update Subscription customer-only section of the Customer Portal. We also plan on making it easier for customers to track cases they have logged, access current and previous version downloads, view licenses and more. 


We don’t expect those changes in the coming months to result in any system downtime, but if they do, we'll make sure to promptly notify you.


As always, serving the community very important to us and we appreciate any feedback. We are always looking to do better. Thanks!


Hotfix 1 for InterBase 2017 Update 1

Written by Marco Cantu, RAD PM on . Posted in Articles

Applies to Product

InterBase (InterBase 2017 Update 1) which was available for download between dates  September 19th 2017 and October 23rd 2017.  


The reason for this hotfix is a crash bug with no workaround in InterBase 2017 Update 1 ( A description of the resolved defects in this hotfix has been added to the Udpate 1 release page at:

Recommended Action

If you have deployed to customers or are using for development InterBase 2017 Update 1, please install this critical update as soon as possible.

How to Get the Hotfix

You can download a patch kit for Windows from

For all platforms, see InterBase registered users download page at

For InterBase 2017 Developer Edition and ToGo Edition: Please install via GetIt in RAD Studio (after uninstalling a previous version of InterBase 2017, if you installed it). This applies both to IBLite/IBToGo and the InterBase Developer Server.

The new version is build

What if I have InterBase 2017

but have not applied Update 1?  Skip InterBase version and install the new build (Update 1 with Hotfix 1).


Advanced ETL Processor Named Embarcadero July Cool App Winner

Written by Jim McKeeth on . Posted in Articles

Somehow I forgot to post that the winner of our Cool App contest for July 2017 was Advanced ETL Processor Enterprise. The extract, transform and load software helps large organizations build data warehouses and automate complicated business processes with ease. Here is an excerpt from our press release about the Advanced ETL Processor Enterprise. It is a great tool, go check it out!

ETL Tools

Built with Embarcadero’s Delphi development tool, Advanced ETL Processor Enterprise ensures data is processed the fastest way possible and tested and profiled constantly. While most ETL tools use hundreds of different connectors, Advanced ETL Processor uses a Universal Data Reader and Writer concept that transforms data based on data definition, regardless of the underlying content. These components are highly configurable and allow customers to reuse their integration mappings again and again as their business data changes.

“One of the most powerful features of Delphi is the ability to work with a variety of databases, data sources and data types,” said Jim McKeeth, chief developer advocate and engineer at Embarcadero. “Advanced ETL Processor Enterprise wraps those features into a powerful application that makes the extraction, transformation, and loading of data simple and easy to manage without writing a single line of code. This is a great example of a Cool App that turns complex data integration into an automated process that doesn’t require training or technical expertise.”

Advanced ETL Processor Enterprise includes a built-in scheduler, business rules designer, package designer, report designer and data browser. The application works with a wide range of data sources, including XML, Access, Paradox, ODBC, Oracle, SQLite, Salesforce, and InterBase. Additionally, it includes support for automation, validations, and transformations on the data as it moves it between data sources.

“Delphi's advanced data access is the key to making a robust tool like Advanced ETL Processor,” said developer Mike Rewnick of DB Software Laboratory LTD. “Embarcadero does the same thing we do: make the complicated simple and empower users.”

Our Cool App contest is open to any business or consumer application built with RAD Studio, Delphi or C++Builder. Qualifying apps can use VCL, FireMonkey, DataSnap, EMS, FireDAC, InterBase and any other components, libraries, services, sites, infrastructures, APIs or devices. Embarcadero awards Cool App contest winners a $500 Amazon gift card and winning submissions are also highlighted on the company’s YouTube channel

CodeRage XII

Written by Jim McKeeth on . Posted in Articles

CodeRage XIICatch the CodeRage Replays! We have saved all the sessions for you. This year included more than 75 sessions and featured Robert C. "Uncle Bob" Martin of Clean Coders and Steven McConnell, author of "Code Complete".

Learn More


Out of the 76 sessions and 58 speakers scheduled for CodeRage XII for 2017, a few notable standouts:

  • Robert C. “Uncle Bob” Martin, author of "Clean Code: A Handbook of Agile Software Craftsmanship", is speaking on “The Clean Coder - An Introduction to Software Professionalism”
  • Steven McConnell, author of “Code Complete”, is speaking on “Managing Technical Debt”. 
  • Marco Cantu, author of the Mastering Delphi series, is speaking on “Introduction to ExtJS for Delphi Developers “
  • Ray Konopka, author of “Developing Custom Delphi Components”, shares his “IDE Productivity Tips & Tricks”
  • Cary Jensen, author of “Delphi in Depth: FireDAC”, speaks on “FireDAC in Depth: Creating and Using Indexes”

Which sessions are you looking forward to the most?

  • [Watch] On-Demand - Working with TlistView - raouf rahiche
  • [Watch] On-Demand - Some code to start building C++ applications - Francisco Muro A.
  • [Watch] On-Demand - Using templates in IntraWeb - Alexandre Machado
  • [Watch] On-Demand - OpenAPI/Swagger: Document and Test your REST API Server - Wagner Landgraf
  • [Watch] On-Demand - Deep Dive: Hospitality Survey App Template Developer Guide - Eli M
  • [Watch] On-Demand - How to develop a simple recommender system - Daniele Spinetti
  • [Watch] On-Demand - All you need know to developer for Windows 10 - Ricardo Boaro
  • [Watch] On-Demand - CAD with RAD, master your OOP skills for multi-plat development - Vsevolod Leonov (Seva)
  • [Watch] On-Demand - Free SSL certificates with Let's Encrypt - Wagner Landgraf
  • [Watch] On-Demand - Customising DataSnap Method Output - Bob Swart
  • [Watch] Tue Nov 7th at 6:00 AM CT - Integrating with Amazon DynamoDB using Delphi Enterprise CDATA Connector - Paweł Głowacki
  • [Watch] Tue Nov 7th at 7:00 AM CT - The Clean Coder - Robert C. "Uncle Bob" Martin
  • [Watch] Tue Nov 7th at 9:00 AM CT - InterBase 2017 ToGo Cross-Platform Development and Deployment - Al Mannarino
  • [Watch] Tue Nov 7th at 9:00 AM CT - Product Address - Sarina DuPont
  • [Watch] Tue Nov 7th at 10:00 AM CT - Storing Data in Amazon S3 with Delphi - Paweł Głowacki
  • [Watch] Tue Nov 7th at 10:00 AM CT - Zen and the Art of Software Extensibility - Bob Calco
  • [Watch] Tue Nov 7th at 11:00 AM CT - Introduction to Ext JS for Delphi Developers - Marco Cantu
  • [Watch] Tue Nov 7th at 12:00 PM CT - VCL Layout Techniques - Ray Konopka
  • [Watch] Tue Nov 7th at 12:00 PM CT - Migrating your C++Builder Projects to Unicode - Al Mannarino
  • [Watch] Tue Nov 7th at 1:00 PM CT - IDE Productivity Tips and Tricks - Ray Konopka
  • [Watch] Tue Nov 7th at 1:00 PM CT - Accessing AWS S3 platform from C++ Builder - Luca Zoller
  • [Watch] Tue Nov 7th at 2:00 PM CT - FMX Animations - Ray Konopka
  • [Watch] Tue Nov 7th at 2:00 PM CT - C++ Builder as a REST server, easy way to comunicate with Apps and SCB's - Dion Mai
  • [Watch] Tue Nov 7th at 3:00 PM CT - Directly Using the Android API - Brian Long
  • [Watch] Tue Nov 7th at 3:00 PM CT - InterBase 2017 Update - Sriram Balasubramanian
  • [Watch] Tue Nov 7th at 4:00 PM CT - FireDAC in Depth: Creating and Using Indexes - Cary Jensen
  • [Watch] Tue Nov 7th at 4:00 PM CT - Docker 101: Introduction to Docker - Jenny Fong, Docker
  • [Watch] Tue Nov 7th at 5:00 PM CT - Preventing and Fixing Coupled Code - Cary Jensen
  • [Watch] Tue Nov 7th at 5:00 PM CT - Matlab/Scilab scripting engine - Janez Makovsek
  • [Watch] Wed Nov 8th at 6:00 AM CT - FmxLinux - FireMonkey for Linux - Eugene Kryukov and Vsevolod Leonov (Seva)
  • [Watch] Wed Nov 8th at 6:00 AM CT - Simplify and speed-up application development with ORM for Delphi - Devart
  • [Watch] Wed Nov 8th at 7:00 AM CT - Creating JSON Wrapper Classes in Delphi - Andrew Sovtsov
  • [Watch] Wed Nov 8th at 7:00 AM CT - Programming Mazes in C++ and Delphi - David Millington
  • [Watch] Wed Nov 8th at 8:00 AM CT - CrossVcl (VCL for Linux and osX) Review - Eugene Kryukov and Vsevolod Leonov (Seva)
  • [Watch] Wed Nov 8th at 8:00 AM CT - Introducing FMXRTL-bringing Right To Left to FireMonkey - Ruhollah Akbarzadeh
  • [Watch] Wed Nov 8th at 9:00 AM CT - TMS Business Showcase: REST Server and ORM (XData and Aurelius) - Wagner Landgraf
  • [Watch] Wed Nov 8th at 9:00 AM CT - Getting Started with Linux using Ubuntu 16.10 , Installing Packages, and Connecting to Servers - Tom Lawrence, Lawrence Systems / PC Pickup
  • [Watch] Wed Nov 8th at 10:00 AM CT - Using PDF Forms as Data Entry User Interfaces in your Delphi Applications - Girish Patil
  • [Watch] Wed Nov 8th at 10:00 AM CT - Bash on Ubuntu on Windows - Kevin Remde
  • [Watch] Wed Nov 8th at 11:00 AM CT - Building mobile apps that connects to Salesforce and SAP/R3 - Fernando Rizzato
  • [Watch] Wed Nov 8th at 11:00 AM CT - Panel: Artificial Intelligence (Davos) - Moderated by Robert F. Smith
  • [Watch] Wed Nov 8th at 12:00 PM CT - Introduction to Sencha Products - Ext JS, Tools, Test, ExtReact, GXT - Sandeep Adwankar
  • [Watch] Wed Nov 8th at 12:00 PM CT - Managing Technical Debt - Steve McConnell
  • [Watch] Wed Nov 8th at 1:00 PM CT - Introduction to Linux Command Line - Steven Gordon
  • [Watch] Wed Nov 8th at 2:00 PM CT - Create SCADA Modbus Industrial Control applications, and Devices with ControlLab, and Visuino Pro - Boian Mitov
  • [Watch] Wed Nov 8th at 3:00 PM CT - Developing Your Own Visuino Components with Delphi - Boian Mitov
  • [Watch] Wed Nov 8th at 4:00 PM CT - Embedding a Chromium browser in a Delphi application - Alex Ruiz
  • [Watch] Wed Nov 8th at 4:00 PM CT - Learning Linux multitasking at the command-line - Tutorials and Training
  • [Watch] Wed Nov 8th at 5:00 PM CT - Integrating the Google Places API into a Delphi application - Alex Ruiz
  • [Watch] Wed Nov 8th at 5:00 PM CT - Create a Business Intelligence (BI) Web Site RAD Style with FireDAC, IntraWeb and UniGUI - Miguel Angel Moreno
  • [Watch] Thu Nov 9th at 6:00 AM CT - Delphi Application Migration  - Al Mannarino
  • [Watch] Thu Nov 9th at 7:00 AM CT - Modernizing your VCL application - Danny Wind
  • [Watch] Thu Nov 9th at 7:00 AM CT - IntraWeb 17 - The Webolution Begins - Chad Hower
  • [Watch] Thu Nov 9th at 8:00 AM CT - CrossTalk - Connecting Delphi and C++ to .NET - Chad Hower
  • [Watch] Thu Nov 9th at 8:00 AM CT - Implementing 2-Step Authentication - Nirav Kaku
  • [Watch] Thu Nov 9th at 9:00 AM CT - Demystifying OOP with RAD Studio and ORMBr - Juliomar Marchetti
  • [Watch] Thu Nov 9th at 9:00 AM CT - Unit Testing and User Interface - Ruhollah Akbarzadeh
  • [Watch] Thu Nov 9th at 10:00 AM CT - FixInsight: Finding Bugs with Static Code Analysis - Roman Yankovsky
  • [Watch] Thu Nov 9th at 10:00 AM CT - GitHub and Git Foundations - GitHub
  • [Watch] Thu Nov 9th at 11:00 AM CT - The Delphi Parser - Automatic Migration Tool - Oren Aviram
  • [Watch] Thu Nov 9th at 11:00 AM CT - Docker for Windows and Windows Containers - Michael Friis and Elton Stoneman, Docker
  • [Watch] Thu Nov 9th at 12:00 PM CT - New feature of Delphi's reporting with FastReport VCL 6 - Denis
  • [Watch] Thu Nov 9th at 12:00 PM CT - Panel: The Internet of Things Is Here (Davos) - Moderated by Robert F. Smith
  • [Watch] Thu Nov 9th at 1:00 PM CT - Single Sign-On and Two-Factor Authentication with Facebook and Google Authenticator - Olaf Monien
  • [Watch] Thu Nov 9th at 1:00 PM CT - Multi-thread CFD example in C++ Builder - Yilmaz Yoru
  • [Watch] Thu Nov 9th at 2:00 PM CT - Plurals, Genders and Abbreviated Numbers with Delphi - Jaakko Salmenius
  • [Watch] Thu Nov 9th at 2:00 PM CT - Microservices with RAD Server - Andrew Sovtsov
  • [Watch] Thu Nov 9th at 3:00 PM CT - C++ and Physics - Mary Kelly
  • [Watch] Thu Nov 9th at 3:00 PM CT - Design Consideration for Multi-Platform Applications - Sarina DuPont
  • [Watch] Thu Nov 9th at 4:00 PM CT - Fast and Furious IDE Tips and Tricks - Alister Christie
  • [Watch] Thu Nov 9th at 4:00 PM CT - InterBase Tips and Tricks - Mary Kelly
  • [Watch] Thu Nov 9th at 5:00 PM CT - Working with Linux Libraries in Delphi - Craig Chapman
  • [Watch] Thu Nov 9th at 5:00 PM CT - Understanding the BlockChain - Jim McKeeth
  • [Watch] Thu Nov 9th at 6:00 PM CT - OpenGL on Linux - Craig Chapman


Replay from last year's CodeRage XI

CodeRage XI



InterBase 2017 Update 1 Is Now Available

Written by Marco Cantu, RAD PM on . Posted in Articles

We are pleased to announce general availability of InterBase 2017 Update 1.

This update expands on the InterBase 2017 version we release earlier this year and introduced many new features as discussed at

InterBase 2017 Update 1 New Features

A highlighted summary of InterBase 2017 Update 1 new features includes:

  • Developer and Server Editions are now available for MacOS Universal build, in both 32-bit and 64-bit platforms
  • Server Edition includes bug fixes for Windows and Linux as well as performance enhancements
  • Support for Windows 10 Creator’s Update
  • SQL features support for Expression Indices, ORDER BY and GROUP BY Expression, as described below

Expression Indices

Expression indices optimize queries based on expressions. By defining the index below, based on an expression referring to multiple fields:

CREATE INDEX idx_expr_t1_udf ON t1
COMPUTED BY (UPPER(first_name) || UPPER(last_name));

a query based on that same expression is going to be much faster:


WHERE (UPPER(first_name) || UPPER(last_name)) = 'THREE MUSKETEERS';

SQL GROUP BY Expression and ORDER BY Expression

The GROUP BY statement can be used with expressions COUNT, MAX, MIN, SUM, and AVG to group the result-set by one or more columns. Similarly the ORDER BY statement can be used with these expressions to sort a resulting dataset. 

/* Following sample queries are optimized to use the expression index, if available; SET PLAN ON to see the plan. Otherwise, the ORDER BY and GROUP BY <expr> will execute by sorting the result set as needed. */

CREATE INDEX idx_expr_t1_mul ON t1 COMPUTED BY (f1 * f2); 

/* ORDER BY */

-- by expression
SELECT f1, f2, f1 * f2 FROM t1 ORDER BY (f1 * f2);

-- by ordinal position
SELECT (f1 * f2), (f1 + f2) FROM t1 WHERE f1 * f2 = 100 ORDER BY 1, 2;

 /* GROUP BY */

-- by ordinal position
SELECT f1 * f2, COUNT(*) FROM t1 GROUP BY 1;

-- by expression
SELECT (f1 * f2), COUNT(*) FROM t1 GROUP BY (f1 * f2);

More Information on Update 1

For a complete list of updates in InterBase 2017 Update 1, please visit our docwiki at

InterBase is the Future for Your Data Layer Needs

Consider these new features along with the current, easily configurable InterBase features like column-level data encryption, field-level change tracking (Change Views), user-specific data visibility, journaling, and point-in-time recovery. InterBase 2017 is a lightweight embeddable database solution that is ideal for distributed systems.

Tips for choosing the best ISV database for you?

If you are looking to choose an ISV database, visit the ISV database comparison on the InterBase pages. Here you will discover a number of questions to help you choose the right database for you.

Download InterBase 2017 Update 1 today!

The Windows and Linux Server Edition updates are provided as a patch install kit for InterBase 2017 customers, while InterBase ToGo and MacOS versions are provided as full install kits. 

Existing Users download the update here:

New to InterBase? 

Learn more at

Buy a license on or from your local Embarcadero reseller parnter

Notice that the trial and developer edition updates will be made available in the coming weeks following final certification, and at the same time we'll refresh the IB 2017 versions distributed via GetIt to the RAD Studio Tokyo customers.


Focus on your product, and stop worrying about your data layer.


InterBase 2017: Embed, Deploy, Relax!



A Busy Summer!

Written by Atanas on . Posted in Articles

It was a busy summer. There has been so much happening lately that it is difficult to decide where to start.

A Busy Summer

Earlier this year we launched the milestone RAD Studio 10.2 (aka Tokyo). This August we released Update 10.2.1 that provided a number of highly anticipated quality and feature updates. So, what happened with the BIG September release? As stated before, we are no longer looking for the next BIG release. We want to provide customers the functionality that they need when it is ready and continue to constantly evolve the product ALL the time. We did 10.2.1 in August, but this week you should be looking for the iOS 11 update. We want to make it easier to stay on the latest release and deliver value more often.


We do have more work to remove the re-installation requirement altogether, but that is not a small task with almost 70K files involved. The good news is that upgrades today are more seamless and our Product and R&D teams received a lot of acolytes for that. The Linux support is a huge milestone and there is a lot more in 10.2.1 for both mobile and Windows.


Our marketing published an awesome magazine to celebrate the progress made with Delphi over the last 22 years I encouraged many of our developers to share this with their supervisors, who think that Delphi is a thing of the past, many were pleasantly surprised. We are running a nice promo for September that goes with the “22” theme, so check-out the site or speak with your partner. It is a great time to upgrade or expand.


The VCL framework continues to evolve. I think that with all the technologies out there, we sometimes forget how good it is, and it is only getting better. High DPI support and improved icons make your apps truly stand-out, and we have plenty of more awesome updates in the works. Lately, we’ve spoken a lot with C++ developers, as we try to increase the awareness for C++Builder. It is amazing how much Delphi developers take for granted. While there are OK visual frameworks that support C++, almost nothing comes close to VCL. I am really excited to continue to educate our C++ community on what we can deliver and of course continue to improve the C++ language support.


At the end of August, we released Enterprise Connectors. These make integration of applications built with RAD Studio to the most common enterprise applications, such as SAP, Salesforce, Facebook, and many more, very easy. They use a combination of FireDAC, REST, and CData technologies to make user adoption seamless. I think that these give an incredible competitive edge to our developer community, especially considering the speed of development. It is fast development indeed.


Just last week we launched the Embarcadero Academy! Making our products more easily accessible for education and making learning easier is a top priority. I feel that a dedicated education site together with a FREE Starter edition that is available for Education purposes are important steps in this direction. I benefit personally… My thirteen-year-old son is learning Delphi and the Academy is making it easy (and inexpensive)! Visit and find out for yourself.


Most importantly, last month we acquired Sencha. This demonstrates again our broader commitment to Developer Tools. Sencha is the home of Ext JS, which is the premier Enterprise framework for JavaScript development. I am super excited for the Ext JS community. Today there are few independent IT organizations with our resources committed to developers. There are also a lot of immediate benefits for our existing Delphi and C++ developers. Over the years RAD Studio provided many Web development options, but none has had the robustness of our core VCL and FMX frameworks. As Web usage exploded, this has contributed for some in the decline of popularity for Delphi. The Ext JS framework is a match to VCL in terms of sophistication and scalability. There are already several good ways to bridge the technologies. As always, we have really smart partners in our technology ecosystems that have developed deeply integrated solutions (e.g. UniGui, Kitto). Developers can also use Ext JS through the REST API connectivity enabled by RAD Server. We will work with our technology partners to make the integration even more seamless.


The product team also just published a roadmap updated for September 2017. It includes plans for the upcoming 10.2.2 and 10.3 releases. There are also details on some research areas R&D is exploring. All of this as we continue our commitment to developers in keeping Delphi, C++Builder, and RAD Studio the premier choice for expert developers everywhere.


After a busy summer, we are all preparing for a busier fall. The community is full of ideas, Block Chains, more IoT support options, better TFS integration, and as always many ideas for language features. Our PMs are busy evaluating ideas and working with R&D on specs. We are open to technology partners and MVPs to participate and introduce products that expand our capabilities, Woll2Wall made an awesome Beacon Editor with FMX, the much anticipated FMX Linux Clients are out, there are cool FMX designer ideas, so much more to come. We’ll demonstrate a lot of these during CodeRage coming November 7th.


This is going to be a productive fall. Get on 10.2.1 and build some awesome apps!

Check out more tips and tricks in this development video: