Progress
Language Tutorial
for Windows


The INSERT Statement

The INSERT works like a combined CREATE and UPDATE statement. Typically, you use INSERT only when you are creating a lot of records, like when you create a new database from scratch. Figure 8–18 shows the data movement of the INSERT statement.

Figure 8–18: Data Movement with the INSERT Statement

This is a partial syntax for the INSERT statement.

SYNTAX
INSERT record 
  [ EXCEPT field ... ] { [ frame-phrase ] } 

INSERT also has implied application blocking.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095