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

Chapter 7. Displaying Query Results > Default Query Results

Default Query Results

When you create a recordset, you are requesting a set of records (hence the name recordset) from your database. The results take the form of one or more records, each containing one or more columns. For more information about fine-tuning your query to get exactly the results you want, see Chapter 4, Using SQL.

In the sample Table 7.1, each entry (name, job, and pay) is a record. Each row is, well, a row, and the user, given the right form, could select just one record (pay for one individual), a column (pay for all individuals), a row (all data in the row for one name, such as Django), multiple rows, or some of each (pay for all names that start with Z).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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