Skip to content

Constants - Database Types

Each report - and each sub-report - can have one type of database (data source).

The value returned by the function DatabaseType can be divided into types using a bit mask. The values returned by an iAnd operation using the C_DatabaseTypeMask constant are:

Constant Description
C_drDF DataFlex embedded Database (including INT file connections to ODBC data-sources)
C_drODBC ODBC data-source
C_drRDS Runtime Data Source
C_drSQLite SQLite Data Source

The ODBC data type (C_drODBC) can be divided into sub-types using a bit mask. The values returned by an iAnd operation using the C_DatabaseSubtypeMask constant are:

Constant Description
C_drStandard No sub-type
C_drSP Stored Procedure
C_drSQL SQL Statement

The SQLite data type (C_drSQLite) can also be divided into sub-types using a bit mask. The values returned by an iAnd operation using the C_DatabaseSubtypeMask constant are:

Constant Description
C_drStandard No sub-type
C_drSQL SQL Statement

Notes

  • Prior to version 6.2, the sub-types C_drSP and C_drSQL were defined as real data sources.
  • With version 7, two new methods have been added: DatabaseMainType and DatabaseSubType.
  • Prior to version 25, the databasetype function returned a folded integer; from version 25, the function returns a value with a bit pattern.