Name

Description

pnVersionNumber

Must be set to the next consecutive number for the database update. It needs be higher than the current system table Entry_Item value, or the OnUpdate event will not get called. See also cDbUpdateHandler for how to set the Entry_Item.

pbVersionUpdate

Private. It is used by class logic to indicate if the OnUpdate event was triggered, thus an actual change of the database was made.

pbRecnum

If the program that is using the source database uses the recnum programming style, the tables should be converted to recnum tables. If the program uses the RowId programming style, converting to standard tables is recommended.

pbToANSI

DataFlex data is stored in OEM format. Non-DataFlex back ends may expect the data to be stored in ANSI format. When defining the conversion options you can define the table character format to be used in the converted table. For more information on this subject, see Character Formats (OEM or ANSI).

pbCopyData

Copies data if a table is to be converted from an embedded to SQL table. The default is True.

pbUseConnectionID

If True (the default); uses the Connection ID of the connection string as defined by the SQLConnection.ini setting. See also: SQLConnections.exe

psSchema

For IBM DB2, Oracle and PostgreSQL databases. Will be read from SQLConnections.ini but can be overridden here.

psBaseTableSpace

The Table_TableSpace for IBM DB2 and PostgreSQL databases.  Will be read from SQLConnections.ini but can be overridden here.

psLongTableSpace

The Long_TableSpace to use for DB2 databases.  Will be read from SQLConnections.ini but can be overridden here.

psIndexTableSpace

The Index_TableSpace for IBM DB2 and PostgreSQL databases.  Will be read from SQLConnections.ini but can be overridden here.