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

Chapter 4. What Every Developer Needs to... > Query Specifications and Limitations

Query Specifications and Limitations

Queries have a number of specifications and limitations that you should be aware of. Fortunately, you will generally not find them too restricting. They are listed in Table 4.3:

Table 4.3. Query Specifications and Limitations
ItemLimitation
Number of enforced relationships32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships
Number of tables in a query32
Number of fields in a recordset255
Recordset size1 gigabyte
Sort limit255 characters in one or more fields
Number of levels of nested queries50
Number of characters in a cell of the query design grid1024
Number of characters for a parameter in a parameter query255
Number of ANDs in a WHERE or HAVING clauseAG99
Number of characters in an SQL statementApproximately 64,000



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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