Skip to content

Browse Data

The above dialog shows an example of the data stored in the name column of the customer table.

The "Show unique value only" checkbox shows only distinct values.

Notes

  • The maximum number of values retrieved from the database is 1000.
  • For the DataFlex embedded database, data is found using the main index of the column or the primary index of the table.
  • For an ODBC and SQLite database, the sorting is performed by the database using the table and column reference.
  • For an RDS table, the data is returned in the order it is stored.
  • DataFlex Reports does not check first whether browse data is supported by the backend, which may result in an error from the database. For example, Microsoft SQL Server reports an error 42000 when attempting to browse data when the column type is text or image based.