Subscribe to this list via RSS Blog posts tagged in Delphi 10.2 Tokyo
FireDACの秘密:最後に挿入された自動生成IDとEnterprise Connectors この記事は Eli M. による Secrets Of FireDac: Last Inserted Auto Generated Id And Enterprise Connectors の抄訳です。  自動インクリメントフィールドがあるテーブルにデータを挿入するとき、一般的にはSQLクエリを使用して新しく作成されたレコードの最後に挿入されたIDを取得します。TFDQueryを使用してINSERTクエリを実行し、続いて、SELECTクエリを実行すれば、新しく挿入された自動インクリメントIDを取得できます。 異なるデータベースには、これを実現するために異なるSQLクエリがあります。 たとえば、MySQLには、LAST_INSERT_ID(例:SELECT LAST_INSERT_ID))という名前で実行できるSELECTクエリ関数があります。 このSELECT文を直接実行するか、FireDAC内蔵の機能を使用することができます。 FireDACには、GetLastAutoGenValueというTFDConnectionコンポーネントから呼び出すことのでき...
Offline Capable Cross Platform Delphi 10.2 FireMonkey Client Code For Android, iOS, macOS, And Windows 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 give you a head start in building your own field service solutions. This blog post is about the offline capable mobile client app that comes with the template. You can download the Field Service Template for free from Embarcade...
Secrets of FireDAC: Pagination With Grids And LiveBindings 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 the query you only deliver the first 20 rows and the next 20 can be requested in the next call. Obviou...
Secrets Of FireDac: Last Inserted Auto Generated Id And Enterprise Connectors 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 has a SELECT query function that you can run called LAST_INSERT_ID() (example: SELECT LAST_INSERT...
Learn How To Replicate A TFDMemTable Into An IBLite Table With FireDAC In Delphi 10.2 Tokyo The Field Service Template client app has offline capabilities which allows you to record changes offline 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 Field Service Template client app that makes this possible is a function which will take the FireDAC JSON that is received from the RAD Server and store it as a table in IBLite. As you will see in the source code below the proce...
Full Featured FireMonkey Mobile Client Source Code For Delphi 10.2 Tokyo On Android, iOS, macOS, and Windows The RAD Server Field Service Template utilizes a RAD Server based REST server module for the server side. On the admin side there is a FireMonkey based desktop client for adding, viewing, and managing appointments. Additionally, the admin client allows you to manage parts inventory and do user administration. The offline capable cross platform client app is built in FireMonkey and it can be deployed to Android, iOS, macOS, and Windows. There is a single codebase and single UI. It allows you to v...
Upload An Attachment To SalesForce With The Delphi 10.2 Tokyo Enterprise Connectors 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 SQL interface to the various APIs that are on offer. This means you don't have to learn new APIs you simply...
Free Field Service App Template Solution Quick Start Guide For Android, iOS, macOS, and Windows 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 tested on Windows but may also run on Linux. This is an excerpt from the RAD Studio Field Service Tem...
Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros 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, in addition to macro substitution you can combine it with conditional substitutions which lets you do the real magic. If you are building your SQL query from scratch using strings you probably have some logic that decides w...
Learn How To Customize The Look And Feel Of The FireMonkey Field Service Template Apps 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 give you a head start in building your own field service solutions. You can download the template from within the RAD Studio IDE using Embarcadero GetIt. You can quickly and easily customize most of the look and feel of the ap...

Check out more tips and tricks in this development video: