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…
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 AdWords, Mailchimp, Facebook, Azure, YouTube, and many many more.
The Enterprise Connectors work through FireDAC and give you an…
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…
Webinar Replay: Embeddable Databases for Mobile Apps: Stress-Free Solutions with InterBase
April 24, 2018
When it comes to developing mobile applications, keeping data on your device is a must-have feature, but can still be risky. With embedded InterBase, you can deploy high-performance multi-device applications that maintain 256-bit encryption, have a small footprint and need…
Author: Shinji Chikugi
この記事は、MARCO CANTUによるDatabase and FireDAC Enhancements in RAD Studio 10.2.3の抄訳です。
私は、Delphi,C++BuilderとRADStudio…
C++ Builder 10.2.2: DataSet Mapping to JSON for JavaScript client support
March 15, 2018
Introduction
In C++Builder 10.2.2, Embarcadero has added a new component to the FireDAC BatchMove architecture, to support generating JSON data from database tables, in an easy and flexible way.
RAD Studio (Delphi and C++ Builder) has offered support for JSON in different…
There are many existing VCL Windows apps built with older versions of Delphi and C++Builder, using outdated technologies and frameworks.In this demo oriented session Paweł is going to walk you through different scenarios of migrating existing Delphi VCL apps to…
Cross Platform Business Stats Dashboard App For Delphi 10.2.1 Tokyo On Android And IOS
September 28, 2017
The Hospitality Survey Client project is part of the Hospitality Survey App template for Delphi 10.2.1 Tokyo that Embarcadero has released through their GetIt platform. The Hospitality Survey App consists of four different projects plus a Survey Question Editor. And now there is a sixth project I am releasing for the Hospitality Survey App which is a Hospitality Survey Admin Client built in Delphi…
