Vues :

Behavior:
Using an SQL command in index enhancement via an external database can cause problems with certain databases, as some of the separators that Active Import uses as standard in SQL queries are not supported by these databases.

Solution:
As from DocuWare 5.1 Fix 2, you can adapt the separators that Active Import uses in SQL queries to your particular database. Similarly you can specify the equal operator. This affects the following characters and operators:

  • ColumnSeparator
  • TableSeparator and Name format
  • Separator for free SQL commands (FreeSelectSeparator)
  • Equal Operator (CharColumnEqualOperator)

The change is made after the Active Import job has been created and then applies exclusively to this job.

To adapt the separator, open the registry editor and navigate to
HKEY_CURRENT_USER\Software\DocuWare\DocuWare\ActiveImport\j<3 digit Jobnumber>\Enhancer

Generate the SQLSeparators key here. Now create the character string values you require for all of the following four components:

  • ColumnSeparator
  • TableSeparator
  • FreeSelectSeparator
  • CharColumnEqualOperator

Examples for ColumnSeparator (%1 is a placeholder for the column name)

%1

No separator (e.g. for FoxPro and SCULPTOR)

`%1

The separator is ` [grave accent] (e.g. for MySQL)

"%1"

The separator is " [double quote] (e.g. for DB2)


Possible values for TableSeparator (%1 is a placeholder for Owner name, %2 for Table name):
*Note: You do not need to enter anything here for databases in which the Owner name cannot be accessed (e.g. FoxPro).

"%2"

Separator for Table name is "[open quotes], the Owner name is not used (e.g. for FoxPro)

%1."%2"

Separator between Owner name and Table name is . [full point], the separator for Table name is " [open quotes] (e.g. for MS SQL)

`%2`

Separator for Table name is `[grave accent], the Owner name is not used (e.g. for MySQL)


Possible values for FreeSelectSeparator:

(%1)

Separators are ( ) [curved brackets] (e.g. for FoxPro, MySQL and PROVEX)


Possible values for CharColumnEqualOperator:

LIKE

Normally ACTIVE IMPORT uses this operator.

=

This operator can be used instead of "LIKE", if "LIKE" does not return satisfactory results, e.g. in DB2 databases..


Examples for the whole configuration
FoxPro database:


MySQL database:


SCULPTOR database:


DB2 database:

Cet article est valable pour les versions DocuWare: 6 6.1 6.5 6.6 6.7 | SQL query Active Import #FAQID_1899