Delphi Win32 -Building Database Application - P7 | Delphi courses

Methodology: We use IBExpert as user interface to run the SQL commands. We start with very simple example and continue with more complex statements.

Technology Used : Firebird, IBExpert, SQL.

Example Constructed: In this video, we will use EMP table, a table that has been created from previous video. We will insert a record into this table and then we build a SQL to insert data from employee table to this table. We will build a SQL statement to update some records of this table as well as a SQL statement to delete records from this table. In the end of this video, we will learn about transaction by modifying this table then call rollback and commit command.

Keyword: SQL, insert, update, delete, transaction.