How to: Edit Data in "Quadrant"
[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]
This topic shows how to perform basic editing tasks in the PetShop database by using Microsoft code name “Quadrant”.
This is the third topic in the "Quadrant" Pet Shop Tutorial.
To edit data
On the View menu, click Explorer, and then click MSPetShop4. The database opens in a new workpad.
Expand Database, and then expand dbo2.
Double-click Product to open it in a new workpad. The data displays in the default table viewer.
In the Product workpad make the following changes:
Change the product Name from Pelican to Pelican2
In the same row, change the CategoryId from Birds to Endangered.
Note the asterisk that indicates that the data has changed.
On the View menu click Changes. A dialog box appears that shows the proposed, original, and database values. In this example, the database value is "N/A" because it is unchanged. “Quadrant” holds the proposed changes in memory until they are committed.
On the File menu click Save. This commits the changes to the database. Note that the asterisk disappears on both the Changes view and in the table.
In this topic you have learned how to edit values and how to compare the proposed values with the old.
The next topic in this series is How to: Edit Stale Data in "Quadrant".
See Also
Tasks
How to: Create a Database from "M" in "Quadrant"
How to: Explore Data In "Quadrant"
How to: Edit Stale Data in "Quadrant"
How to: Resolve Change Conflicts in "Quadrant"
How to: Edit Complex Data in "Quadrant"