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

Chapter 10. Understanding Jet Operators ... > Intrinsic and Named Constants

Intrinsic and Named Constants

As noted earlier in this chapter, VBA and Access have many predefined intrinsic constants. The names of these constants are considered keywords because you cannot use these names for any purpose other than returning the value represented by the names, such as -1 for True and Yes, and 0 for False and No. (True and Yes are Access synonyms, as are False and No, so you can use these pairs of values interchangeably in Access, but not in VBA.) As noted throughout the chapter, Null indicates a field without a valid entry. True, False, and Null are the most commonly used VBA intrinsic constants.

T-SQL

T-SQL uses 1 for TRUE and 0 for FALSE. Conversion between -1 for True and 1 for TRUE succeeds because True accepts any non-0 number as Not False. The Upsizing Wizard converts Jet Boolean fields to the SQL Server bit data type.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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