Please enable JavaScript to view this site.

Altova DatabaseSpy 2020 Professional Edition

Entering data manually in a database table is another way to insert data in the database. This approach does not require you to write any SQL queries because all of them are generated by DatabaseSpy as you work.

 

1.Open the "ZooDB" project created previously and double-click the dbs_ic_connected ZooDBConnect data source to connect to it.

2.In the Online Browser, right-click the tblFeedSuppliers table and select Edit Data from the context menu; alternatively, select the table and press Ctrl+Alt+E.

3.DatabaseSpy generates a SELECT statement in a new SQL Editor window, automatically executes it, and displays the table's data in the Result window for editing. A dialog box appears, informing you that editing of data is limited for this table. This warning merely indicates that the table is designed with automatically incremented columns. Such columns are automatically updated by the database upon inserting the record, so you cannot type data into such columns manually. All other columns can still be updated manually.

dbs_zoo_insert_manually_01

4.In the Result window, click the Append a new row dbs_ic_append button. Note that the cursor automatically appears in the "SupplierName" column because the value for the "SupplierID" column will be generated automatically by the database.

dbs_zoo_insert_manually_02

5.Enter some data into the newly created row, for example:

dbs_zoo_insert_manually_03

6.Click ic_commit to save the changes to the database.

 

The edits are now committed to the database. On success, the message ic_status_okExecution was successful appears at the base of the Result window.

 

Since the SQL Editor still displays the SELECT statement for this table, click Execute ic_execute-sql or Execute for data editing ic_edit-data to retrieve data from the database again and display the table updated with your changes.

© 2019 Altova GmbH