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

Chapter 4. Unleashing the Power of Queri... > Understanding Dynasets and Their Und...

Understanding Dynasets and Their Underlying Tables

As already mentioned, a select query retrieves records according to the description you provide in the query design grid. These records are called a dynaset. The resulting datasheet result looks like a table, but it has different characteristics.

A dynaset is dynamic and temporary. In contrast, a table is static and permanent. A dynaset reflects what is in the underlying table when the query is run. When the query is closed, the dynaset goes away. Dynamic, according to the dictionary, refers to a tendency to change. If the table data changes, when the query executes, the dynaset generates the current picture of what is there. The important thing to remember is that when you save the query, you are saving the query design that generated the dynaset rather than the dynaset itself.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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