The next table lists the statements used to access a relational database.
Statement | Purpose |
---|---|
Add | To add a row. |
Close | To close an SQL data source or a result set. |
Delete | To delete one or more rows. |
Execute | To run either a prepared SQL statement or a set of one or more non-prepared SQL statements. |
ForEach | To define a loop that retrieves each row in an SQL result set and operates on the most recently retrieved row. |
Get | To retrieve one or more rows. |
Open | To open a result set. |
Prepare | To create a prepared statement. |
Replace | To update a row. |