The Statement Type group box is in the New SQL Statement dialog box.
SELECT Multi-Row |
Creates a SELECT statement that retrieves multiple rows of data and generates positioned EASEL action routines when you compile the SAM. |
SELECT Single-Row |
Creates a SELECT statement that retrieves a single row of data. |
UPDATE Searched |
Creates an UPDATE statement that updates one or more rows of data. |
UPDATE Positioned |
Creates an UPDATE statement that uses the WHERE CURRENT OF syntax to update a single row of data pointed to by the current position of a cursor. |
DELETE Searched |
Creates a DELETE statement that deletes one or more rows of data. |
DELETE Positioned |
Creates a DELETE statement that uses the WHERE CURRENT OF syntax to delete the row pointed to by the current position of a cursor. |
INSERT |
Creates an INSERT statement. |
Creates any type of SQL statement other than SELECT, UPDATE, DELETE, or INSERT. |