A common pattern when inserting data into a database table which has an auto increment field set on it is to use an SQL query to select the last inserted ID of the newly created record. Once you use your TFDQuery to run your INSERT query you can run this second query to get the newly inserted auto increment ID. Different databases have different SQL queries to accomplish this. MySQL for example…
Free Field Service App Template Solution Quick Start Guide For Android, iOS, macOS, and Windows
July 22, 2018
The RAD Server Field Service Template consists of three main components and a setup application (also check out the deep dive). The Field Service Admin app has been tested on Windows and macOS (but probably also runs on Android and iOS). The Field Service App has been tested…
If you are using FireDAC and building your SQL queries manually you may be using more verbose code than is needed. FireDAC has a feature called Macros which allows you to do a variable substitution in your SQL query similar to parameter substitution but for raw SQL. However…
Note: This is not a comprehensive security tutorial for RAD Server merelya tech tip.
There are a number of sections in the emsserver.ini file which can help you secure your RAD Server for production which include Server.APICrossDomain, Console.Login, Server.Authorization. You can limit cross site scripting by changing the CrossDomain setting in Server.APICrossDomain to only allow your…
Migrating is easier than you think!
December 26, 2017
As an Embarcadero Software Consultant, I’m often asked to help migrate legacy Delphi and C++ Builder code to the current versions. Developers have commented that their migrations were easier than they thought! Here are two recent Code Rage Sessions showing Migrating your…
Building Perfect REST APIs with RAD Server and Delphi
December 3, 2017
REST API architecture has become the most popular approach for building scalable, secure, multi-user systems.Using RAD Server you can quickly publish your Delphi or C++ logic as HTTP REST API endpoints that can be used from any app and framework, including mobile…
RAD Studio 10.2: Windows 10 VCL UWP/WinRT Support
September 29, 2017
Windows 10 VCL Universal Windows Platform (UWP)/WinRT Services and Components has been added to the Run Time Library (RTL).
For example, the Windows 10 Notifications Componentand Windows 10 Sharing/Contract Component, for both Object Pascal and C++ is included in RAD…
Learn How To Use AngularJS To Quickly And Easily Connect And Consume JSON From RAD Server
September 13, 2017
The Hospitality SurveyAdmin dashboardproject is part of the Hospitality Survey App template for Delphi 10.2 Tokyo that Embarcadero has released through their GetIt platform. The Hospitality Survey App consists of four different projects. In this blog post I am…