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”Creating and extracting ZIP archives in Delphi
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”Using the Filter in Delphi datasets
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”Create an indexed list from dataset in Delphi
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”Delphi 10.4.2 is released
Embarcadero has just released the new version 10.4.2 of Delphi.
Continue reading “Delphi 10.4.2 is released”