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

Chapter 20. Exploring Access Data Projec... > Exploring SQL Server Views

Exploring SQL Server Views

Like tables, views open in conventional Access datasheets. Figure 20.12 shows the Order Details Extended view, which is almost identical to the Jet version. The Expr1 column duplicates the ProductID column, a minor fault in the NorthwindCS.sql script. Although the new project designer has an extended Format property for columns, the script doesn’t set this property value, nor does it set the Caption property. Access 2003 continues to display the Discount field as a decimal fraction, instead of a percentage. The Datasheet View toolbar for views is identical to that for Jet queries. Like tables, the Sort Ascending, Sort Descending, Filter by Form, Filter by Selection, and Find buttons of the toolbar operate on the locally cached copy (snapshot) of the view’s Recordset, not the view itself.


Figure 20.12. NorthwindCS’s Order Details Extended view has a spurious Expr1 column, doesn’t format the Discount column as percent, and doesn’t emulate the Jet version by setting the Caption property for the columns.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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