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”
Since version XE2, Delphi is shipped with the built-in unit “System.Zip” for creating, editing and extracting ZIP compressed files. It is based on the RTL, and it can work slightly with VCL and FMX frameworks on all supported targets.
In this tutorial, we will show you what are the abilities of this unit and how to use it properly.
Continue reading “Creating and extracting ZIP archives in Delphi”
One of the best implemented features in Delphi datasets is the filter (records filtering). This built-in tool work by combining SQL filtering commands and string options like case sensitivity.
In this quick tutorial, will show you how to use the filter effectively.
Continue reading “Using the Filter in Delphi datasets”
In apps development, there many times when you have a large dataset filled with records. And you want to create a list of the items used in the records, without repeating. Like, for example, making a list of countries visited by the people in your dataset.
In this tutorial, we will show a good way to do that.
Continue reading “Create an indexed list from dataset in Delphi”
Embarcadero has just released the new version 10.4.2 of Delphi.
Continue reading “Delphi 10.4.2 is released”
In today world, media contents (like apps, websites, etc.) must have a responsive layout that can be adapted and adjusted quickly to suit to the orientation and the size of the platform’s screen on which they are runned.
Continue reading “Create responsive apps by using screen orientations in Delphi FMX apps”