Delphi FireDAC datasets offer a quick and easy sorting feature, through the property “IndexFieldNames” in which you list the field names to use as an index, and you can optionally specify sorting options for each field.
Continue reading “Sorting records in Delphi datasets”Launch external apps from Delphi Android apps
It is common to make your Android apps able to launch and send data to external apps by using intents. But there are also situations when you want your Android app to only launch an external app without passing any data.
This tutorial will show you how to implement this feature :
Continue reading “Launch external apps from Delphi Android apps”Replace strings in Delphi dataset records
How to replace a string quickly in the whole dataset ? How to create a fast replace dialog for your app’s datasets ?
In this tutorial, we will explains the right procedure to implement a replace feature for your Delphi datasets.
Continue reading “Replace strings in Delphi dataset records”Difference between adding a unit to the interface or the implementation section
Object Pascal units have two sections (interface and implementation), and as you can see in many source code, each section can have distinct items (uses, types, variables, and constants).
So, which section is suitable for putting a unit as uses ?
Continue reading “Difference between adding a unit to the interface or the implementation section”Delphi 11 is released
Officially on September 9th, Embarcadero released the new version 11 of Delphi, named “Alexandria”.
Continue reading “Delphi 11 is released”How to flatten a table in Excel
In most times of collecting and writing data tasks, you will use a spreadsheet software like Microsoft Excel. And you end up with a two dimensions table where each key has a dedicated column.
Of course, it is a simple table, easy to be read by humans. But if you want to transform it to a dataset or a list of keys/values, to be imported into a database system, then you must convert your 2D table to a flat table.
This tutorial will show you how to flatten a table in Excel, using VBA script :
Continue reading “How to flatten a table in Excel”