How to create Auto Incremental Fields in RAD Server with InterBase, FireDAC and TEMSDataSetResource
One key feature when asking a remote server to add a record is to get the new record ID value returned. Thankfully this is easily achieved with InterBase and FireDAC via RAD Server with TEMSDataSetResource
InterBase has a concept of Generators. These provide a unique sequential integer value that can be used to provide a primary key field value. You can create up to 32,767 Generators in an InterBase database, but typically you would create one for the database or create and name one for use per table.
Part of the FireDAC framework is the ability to treat database fields as Auto-Incremental Fields. For Databases that do not have an AutoIncremental field data type, you can set the UpdateOptions properties to define the Generator and key fields.
The sheer volume of data that is collected has exploded in recent years thanks to digitalization and modern cloud architectures that support massive data collection, and encourage widespread cross-sharing of data.
The growth trend of having applications with easily accessible API’s, provide a rich base for rapidly adding functionality, and choice of functionality to new applications, based on existing software that is already being widely used. – Enabling a customer to expand their existing systems easily through the choice of software is a real example of Open Innovation. This approach makes it easier to get your software adopted into a customer’s existing business capabilities.
After the previous session talking about working from home under Covid19, we asked for input on what you wanted to discuss. From the ideas submitted, we picked a discussion around the IDE.
We aim to share top tips and tricks, and also, as David is the Senior Product Manager responsible for RAD Studio IDE, (along with Visual Assist, – the Visual Studio plugin from Whole Tomato for C++ and C#), we should get some great insight to the background around a number of recent changes, and what to expect moving forward too!
As software developers, on the whole, it’s relatively simple to switch to working from home, and many of us work from home regularly, or all the time. However, with a quarter of the world’s population already in lockdown, the circumstances are not exactly the same as your typical week at work.
With a majority of workers now trying to work from home, the daily mix of office news, banter, and general togetherness has been dramatically changed.
This month has seen an ever-changing global situation with the outbreak of the coronavirus. The first time that I can remember I had to radically change / cancel a live event due to circumstances out of our control.
At the start of March we were keeping an eye on the news to see how the spread of the coronavirus had impacted Denmark. With only 2 cases in Denmark, the advice at the time was that it was set to travel and we proceeded with events in Kolding and Copenhagen. Especially nice to see was a growing number of new and younger faces, and a good proportion who’s first-ever version of Delphi or C++Builder what 10.something.
This week, Delphi is turning 25, and as part of the celebrations, members of the community have been encouraged to share their stories about Delphi, what they love and how it has helped their careers.
Delphi was originally launched on the 14th of February 1995, while I was still at 6th form College. It kind of passed me by, to be honest. At the time, I was just purchasing (well my parents did) my first PC with Windows on it. I was, however, using Pascal in the computer labs in some elective modules I took alongside my primary studies. (Progressing on from Basic).
Creating and connecting to MSSQL Database on Azure with Delphi / C++Builder
I have been asked multiple times recently about connecting to a Azure databases with Delphi and C++Builder. So….I decided to make a video! Which even shows how to use the data directly at design time in the RAD Studio IDE.
The video follows the the 3 phases.
Creating an account
Creating a database
Connecting to the database from the RAD Studio IDE