Modifying formulas for a different database type

When you use the File Import Wizard or Database Integration Wizard to develop a template, that wizard will use the database messages from the table below to check for duplicate records:

GainSeeker database:

database message:

SQL Server

"DUPLICATE KEY"

Oracle

"UNIQUE CONSTRAINT"

Pervasive.SQL

"DUPLICATE KEY"

MySQL

"DUPLICATE ENTRY"

Thus, if you develop such a template on one type of GainSeeker database and then try to apply it on a different type of GainSeeker database, you must update your template code to accommodate the new database type.

To find all instances of the original database message in any of your templates, use the Text Search utility. To find all instances of the original database message in a single template, use the Find button.