role_first

[sql.config DP4_database_name]
role_first=0

role_first=1 effectively allows reversal of the field name and role order.

This may be useful if you have several SQL databases created in different ways. For example if you create an Access database from a DP4 database and the DP4 database contained a field staff_name with a role of manager, the Access database name will contain a field called manager$staff_name. So for this database you would specify role_sep='$' and role_first=1, which will allow you to use the existing DP4 database to access the Access database. Otherwise you would need to use AUXWINST to create a new DP4 database with amended names.