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

Workshop

The quiz questions and activities are provided for your further understanding of the current hour's topics.

Quiz

1:What's wrong with the following record selection formula, and how would you fix it?
{Orders.Order Date} > "2/25/2000" 

A1: This record selection formula is comparing a date to a string literal. The string on the right would need to be converted to a date-time value before making this comparison. One of the possible solutions is
{Orders.Order Data} > #2/25/2000# 

2:What is the purpose of a SQL Expression?
A2: The purpose of a SQL Expression is to create a formula that is processed on the database server to either use a database-specific function, or to ensure maximum performance when using that formula in the record selection formula.
3:How are triggered alerts displayed to the user?
A3: When an alert is triggered, it is displayed to the user in the form of a pop-up dialog, as shown in Figure 15.3.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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