download the application please visit www.mrbool.com/player
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
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.