C++ Builder - Creating InterBase database on the fly at run-time using FireDAC Sometimes you have the need to create your InterBase database on the fly in code at runtime, for example, if a user downloads your application and runs the application for the first time, and your app needs to create and use a database with the application.  On Single or Multi-Device platforms, this would save you from having to deploy the database file and also setup the paths for deployment reducing your upfront work.   From Connect to InterBase (FireDAC), looks like ...
How to insert an InterBase blob with RAD Studio using FireDAC and LoadFromFile I was asked today if RAD Studio had any easy way to insert a blob (picture image) into an InterBase blob column? This is one way of inserting blob data using C++ Builder or Delphi.  There are several ways to accomplish this task.  This example is just one way of doing it. This example is using the FireDAC LoadFromFile method. Create a table in an InterBase database with a field that can store non-text Blobs:   create table table1 (images blob sub_type 0); Using C...

Posted by on in Blogs
Use TRESTDataSetAdapter with arbitrary JSON One basic question I get asked is how can I convert arbitrary JSON into some kind of data structure such that I can extract useful data? One solution is to use the TRESTDataSetAdapter with arbitrary JSON. The TRESTDataSetAdapter and TClientDataSet components convert the JSON representation into a dataset. The TRESTDataSetAdapter has many nice functionalities, but some developers assume you are getting the JSON back from a REST call. But, you can use TR...
FireDAC & ODBC for Paradox and dBase tables. I continue to get customer requests for options to migrate legacy RAD Studio, Delphi or C++ Builder applications using the Borland Database Engine (BDE) with Paradox and/or dBase files.              With the current versions of RAD Studio, you can use the FireDAC ODBC bridge driver to get to Paradox and dBase tables.  This is important if you want to keep your legacy Paradox or dBase tables when you are migrating to newer versions of RAD Studio, Del...

Posted by on in Blogs
Learn C++ using C++ Builder | Free Event Learn C++ using C++ Builder | Free Event! NYC on Sunday, June 4 from 12 pm noon to 6 pm Byte Academy  295 Madison Ave Fl 35, New York, NY (map) Register here:  https://www.meetup.com/Byte-Academy-Finance-and-Technology-community/events/240003747/   One codebase, one UI designer, four platforms (Windows, Max OS X, iOS, and Android). Powerful database and enterprise frameworks; unparalleled speed of development. Embarcadero® C++Builder 10.2 Tokyo Starter is a great way to g...

Posted by on in Programming
FireDAC and Microsoft Azure SQL Database I've started to get requests to use FireDAC with Cloud Databases, like SQL Azure.  The question whether or not to put your business data in the cloud is getting easier and easier these days and a lot of that is thanks to Microsoft's investment in Microsoft Azure.  Microsoft's strategy to create an infrastructure, like Microsoft Azure SQL Database, that can manage big data (as big as petabyte-scale) and everything on down from that is working and it's working well.  In t...
Getting Started using RAD Studio 10.2 Tokyo RAD Server Multi-Tenancy Support Embarcadero has many resources on RAD Studio 10.2 RAD Server and the new Multi-Tenancy Support.      This post highlights a few of the additional resources for RAD Server Multi-Tenancy Support.  RAD Server Multi-Tenancy Support / EMS Multi-Tenant Console - This docwiki link is a great place to start for details on RAD Server Multi-Tenancy Support, and using the EMS Multi-Tenant Console. Toy Store RAD Server Multi-Tenancy Application ...
RAD Studio 10.2 Tokyo RAD Server Multi-Tenancy Support The new 10.2 Tokyo RAD Server introduces Multi-tenancy Support.  With Multi-Tenancy support, a single RAD Server instance with a single RAD Server database connection can now support multiple isolated tenants or customers.  And each tenant has a unique set of RAD Server resources including Users, Groups, Installations, Edge Modules, and other data.  And a RAD Server Tenant Administrator can Create new tenants, edit existing tenants, add, edit or delete details of your tenants, spe...
RAD Server EMS Package to get data from a remote database through a REST API call and display the data on an EMS Client application. Embarcadero's Enterprise Mobility Services (EMS) is a turnkey middleware solution, part of RAD Server that supports secure, encrypted communication using an industry-standard REST interface. With built-in support for users and groups, EMS is a perfect platform for exposing your custom REST endpoints to a wide range of authorized clients. Developers will especially appreciate the ease with which corporate data and features can be securely accessed from mobile clients, which normally lack th...
Build a secure multi-device application using encrypted InterBase ToGo database Build a secure Multi-device Application Using Embedded encrypted InterBase ToGo In Part 1, we showed how to add database and column level encryption to an InterBase ToGo database.  In this Part 2, we show how to build a secure multi-device application that uses our encrypted InterBase database. In Part 1, we saw how to get our InterBase ToGo Deployment license.  Now we show the steps to build a secure multi-device application using RAD Studio, Delphi or C++ Builder and our ...

Check out more tips and tricks in this development video: