Database Operation In-Action
This page guides you through demonstrations of live database operations using the
SQLData Desktop Server. The pages you will see by clicking on the links below
are generated dynamically by the server. Since our demo server is on a different machine, you will need to
use the Back button to come back to this page after each operation.
- SQL
Queries: When a query is issued to the server. The server retrieves data from the
database and formats the data into HTML elements. The server also adds hyperlinks to the
record details so that on screen editing can be performed.
- Updating
Records: The server formats the specified record as standard HTML forms according to
the data type and length of each field. You can then make changes in the form and click
the Update button to save the record.
- Inserting
Records: Adding a new record is very easy. The server creates an empty form for
inserting new records into the database tables. Click the Insert button after entering a
new record.
- Deleting
Records: There is a Delete button on the record editor page. Click the button will
remove the record from the database table
- Final
Review: If you have followed all the steps above. This is the final result.
|