Opening SQLite Tables Using Column and Row Filters - MapInfo_Pro - 2023

You can apply column and row filters on a SQLite database table before opening it in MapInfo Pro. Filters let you choose which columns and rows to fetch from the data source. You would do this to reduce the amount of information that you will work with and reduce the time it takes to fetch and save the data.

To apply column and row filters on a SQLite table when opening it:

1. On the HOME tab, in the File group, on the Open list, click Table to open the Open dialog box.
2. From the Files of type list, select SQLite Database (*.sqlite).
3. From the Look in list, select the folder location of the SQLite database that you want to access.
4. From the files list, select the SQLite database to open.
5. Click Open to display the Select One or More Tables to Open dialog box.
6. In the Database Tables list, select one or more tables to open.
7. Click Options to open the Open DBMS Table Options dialog box.
8. Select Standard Mode and then click Column Filters.

   The Column Picker dialog box opens.

9. Choose which columns to fetch from the table and then click OK.

   For information about setting column filters, see Setting a Column Filter.

10. Select Row Filter to open the In the Row Picker dialog box.
11. Choose which rows to fetch from the table and then click OK.

    For information about setting row filters, see Setting a Row Filter.

12. If working with large data files, larger than 2GB, then under MapInfo TAB File select MapInfo Extended from the Format list. You can also select the character set of the data file from the Charset list.
    Note: The default Format and Charset settings are software preferences, see Setting Your Language Preferences.
13. Click OK to close the Open DBMS Table Options dialog box.
14. From the View list, select how you want to open the tables.

    Select New Mapper or Current Mapper to open them in a Map window, or Browser to open them in a Browser window to see the table contents.

15. Click OK.

The table opens in MapInfo Pro with only the columns and rows that you selected to fetch.

To create your own table filter in standard SQL syntax, see Creating Your Own Table Filter.