Title: Delphi Win32 - Building Database Application – P7
Duration: 15:31 min
Description: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.This video will be started by inserting data to a table. We will see how to insert a single record to a table and also how to insert from another table as well. Then, we will talk about update and followed by delete command. At the end of this video, I will introduce you about transaction.
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.