The number of blocks that Database Manager retrieves from a query depends on how broad your request is. If the query is broad (for example, display all Analog Input blocks) the program retrieves more blocks than if the query is narrow (for example, display all Analog Input blocks with a scan time of five seconds and a name that begins with "Q"). You can adjust the number of blocks retrieved by refining or expanding your query.
One way to refine a query is to start with a simple query and append other queries to it. For example, the following query displays all the Analog Input blocks in the database.
{Type} = "AI"
Once Database Manager retrieves these blocks, you can refine the query by adding other queries to it. For example, you could add the following query to display only the Analog Input blocks with a scan time of two seconds:
AND {Scan Time} = "2"
Similarly, you could increase the number of blocks in the spreadsheet by displaying all the Analog Input blocks and then, to the original query, add all Analog Output blocks in the database with the following query:
OR {Type} = "AO"
