• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. What Every Developer Needs to... > Understanding How Query Results Can ...

Understanding How Query Results Can Be Updated

If you haven't realized it yet, the results of your query can usually be updated. This means that if you modify the data in the query output, the data in the tables underlying the query is permanently modified.

Build a query based on the Customers table. Add the CustomerID, CompanyName, Address, City, and Region fields to the query grid, then run the query. Change the address of a particular customer, and make a note of the customer ID of the customer whose address you changed.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint