If you want to display only a range of results from a recordset you can using paging (otherwise known as pagination) to do so. It is a common pattern when doing web development to give the user 20 results for example and then the ability to move to the next page. If you are implementing a REST API in RAD Server you might also implement this functionality instead of delivering 2 million rows for…
Secrets Of FireDac: Last Inserted Auto Generated Id And Enterprise Connectors
August 30, 2018
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…
Learn How To Replicate A TFDMemTable Into An IBLite Table With FireDAC In Delphi 10.2 Tokyo
August 23, 2018
The Field Service Template client app has offline capabilities which allows you torecord changesoffline without an internet connection. Later updates can be sent back up to the RAD Server once an internet connect is detected. One of the pieces of code in the…
Full Featured FireMonkey Mobile Client Source Code For Delphi 10.2 Tokyo On Android, iOS, macOS, and Windows
August 23, 2018
For the server-side, the RAD Server Field Service Template makes use of a RAD Server-based REST server module. On the admin side, there is a desktop client based on FireMonkey for adding, viewing, and managing appointments. You can also use the admin client to manage parts inventory and user administration. FireMonkey was used to create the offline-capable cross-platform client app, which can be…
Upload An Attachment To SalesForce With The Delphi 10.2 Tokyo Enterprise Connectors
August 7, 2018
I am working on a project that utilizes the Embarcadero Enterprise Connectors powered by CData to access SalesForce through it’s API. The Enterprise Connectors provide you a wide variety of connectors for quickly and easily accessing APIs like SalesForce, Google…
Miniatur Wonderland Hamburg is the world’s largest model train set as officially certified by the Guinness World Book of Records. Apparently the whole system is powered by software built in Delphi on the back end (including the control room). Embarcadero’s Jim…
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 on Android, iOS, macOS, and Windows. The Field Service Setup has been tested on Windows. The Field Service Server has been…
Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros
July 19, 2018
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…
Learn How To Customize The Look And Feel Of The FireMonkey Field Service Template Apps
July 17, 2018
The RAD Server Field Service Template provides an end to end field service application template for routing appointments, managing parts, and user administration. It is made up of a REST server module, a desktop client, and a cross platform mobile client. The template can…
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…
