Consultor Eletrônico



Kbase P5234: 4GL trigger code being accessed via ODBC cannot call another
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   27/01/2003
Status: Unverified

SYMPTOM(s):

SQL-89 client successfully fires a 4GL Trigger.

Code being accessed by trigger does not work.

Code being accessed by trigger is attempting to connect to another database.

Connecting to first database via Merant 32-bit SQL-89 ODBC Driver.

CAUSE:

Need to connect to all databases through ODBC. In this case the trigger code is a acting as a seperate 4gl connection.

FIX:

Use the databse connections list to connect to multiple databases.