WEBDEV Concepts

Part 5: Databases 181 Table control populated programmatically In this case, the Table control directly displays the data loaded in memory. The data is added to the Table control programmatically (with TableAddLine , for example). Data in memory When data is in memory, you can perform different actions in the Table control (sort columns, search in columns, etc.). Table control with in-memory data source Table controls with in-memory data source combine the advantages of Table controls with direct access to the data source and Table controls populated programmatically. The Table control is linked to the data file but the entire content of the data file is loaded in memory. Sort and the search features are available for all columns. The data that is not linked to the data file is not lost when moving the scrollbar (in Check Box columns, for example). Since the data file records are loaded in memory, this type of control is recommended for data files with less than 100 000 records (to avoid memory overflow). File loaded in memory Customer file Remark : The different modes to populate the controls (programmatically, with direct access to the data source and with in-memory data source) are available for different types of controls: List Box, Combo Box, Table, Looper, etc.