Disable triggers for dynamic query

HarryK

New Member
Hello,

I am trying to create / modify a record in an existing
progress database using a dynamic query.
The table has a write trigger
All works wel until the release.
Then the write trigger excecutes , modifying some other tables.
I don't want to modify those other tables, so
Is there a method like
hBuffer: DISABLE-TRIGGERS() .:)
Doing the same like :
Disable triggers for load of sometable.

Program example:

DEFINE VARIABLE H_QUERY AS HANDLE NO-UNDO.
DEFINE VARIABLE H_BUFFER AS HANDLE NO-UNDO.

CREATE QUERY H_Query.
CREATE BUFFER H_buffer FOR TABLE 'sometable'.
H_Query:SET-BUFFERS(H_Buffer).
H_Query:QUERY-PREPARE("FOR EACH sometable").
H_Query:QUERY-OPEN().
H_Query:GET-FIRST().
DO TRANSACTION:
/*********************************************/
/* h_Buffer: DISABLE-TRIGGERS(). ?????????????*/
/*********************************************/
h_Buffer:BUFFER-CREATE().
/* some assign statements */
h_Buffer:BUFFER-RELEASE().
END.
H_Query:QUERY-CLOSE().

DELETE OBJECT H_buffer NO-ERROR.
DELETE OBJECT H_Query NO-ERROR.

Regards in advance,
 
Methods... apply to Buffer Object handle.

Disable-dump-triggers()
Disable-load-triggers(allow-replication)

Grts,
Jan
 
Back
Top