Kbase 15149: Schema ( Database ) Triggers and ODBC and HLC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Schema ( Database ) Triggers and ODBC and HLC
Can Schema Triggers reside on the Server Machine?
-------------------------------------------------
Triggers must reside on the CLIENT machine in
Progress versions 7 and 8; they CANNOT reside on the
server.
Will Schema Triggers fire when accessing DB via ODBC?
-----------------------------------------------------
Schema triggers will fire when accessing the Progress
database from another application such as MS-ACCESS via
ODBC. The triggers will execute in the OI driver.
In a Schema trigger can you use HLC to call a C function?
---------------------------------------------------------
It is possible to use HLC from within a schema trigger
to CALL a C routine; however, HLC requires using PROBUILD
to re-build the client. The OID is not PROBUILDable,
therefore if a schema trigger uses HLC and is accessed from
the ODBC driver, the CALL to the c-routine in the trigger
will FAIL.
Progress Software Technical Support Note # 15149