Delphi Win32 -Building Database Application

This video is the first part of a video set about Building Database Application with Delphi, Firebird and dbExpress. In this video we will talk about introduction to database application with Delphi in general.

There are many aspects on developing database application with Delphi. One of them is how to manage and process data in local memory. Delphi gives us an alternative to do that with a descendant of a Dataset component called ClientDataset.

Field is the element of dataset. In the real world application, you will intensively work with fields. The basic type of field is TField object and it has different descendant for different data type, for example TFloatField, TIntegerField, TStringField, etc.

Insert, Edit, and Delete are the basic operation to modify dataset. Although they can be done very easy with user interface component like DBGrid or DBNavigator, as a Delphi programmer you have to know how to do that at run time. This video covers how to modify data inside TClientDataset at runtime.

There are many searching methods we can use with ClientDataset, fore example are Locate, Lookup FindKey and FindNearest. Locate will find and move cursor if specified record is found, but lookup doesn’t. Findkey and FindNearest are searching method that use index. Findkey is used to find data and move the cursor if found. FindNearest used to moves the cursor to the record that most closely matches a specified set of key values.

In this video, we will start discussion about SQL, specifically we will talking about query data with SQL. We will learn about query data with very simple SQL command with basic query statement.

This video will show you how to modify data with SQL. The basic knowledge of updating data with SQL is very usable for you to create database application.