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,
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,