Disable trigger from 4gl

Chrys777 · #1 (**permalink**) 06-17-09, 09:38

Hello

I am trying to disable all the triggers of a table before updating some records. This is my code:

Code:

prepare s_trigger_off from "set triggers for table disabled"
execute s_trigger_off

prepare p_stmt from stmt
execute p_stmt 

prepare s_trigger_on from "set triggers for table enabled"
execute s_trigger_on

I get the following error:

Code:

Program error at "update.4gl", line number 80.
SQL statement error number -242.
Could not open database table (database.table).
SYSTEM error number -106.
ISAM error:  non-exclusive access.

Any ideas what I am doing wrong?

Luis Santos · #2 (**permalink**) 06-17-09, 21:08

Hi,

Do you database is with transactions?

If no, then you should use first "LOCK TABLE tablename IN EXCLUSIVE MODE", after that "UNLOCK TABLE tablename"

If yes, you need to use "BEGIN WORK" before you update statement and "COMMMIT WORK" after the execution.

I hope it works.

Bye.

Chrys777 · #3 (**permalink**) 06-19-09, 10:40

Quote:

Originally Posted by Luis Santos

Hi,

Do you database is with transactions?

If no, then you should use first "LOCK TABLE tablename IN EXCLUSIVE MODE", after that "UNLOCK TABLE tablename"

If yes, you need to use "BEGIN WORK" before you update statement and "COMMMIT WORK" after the execution.

I hope it works.

Bye.

I found the problem. I was performing a fetch command that was locking the table. I changed it to execute and is working fine now. Thanks for the help Luis

Internet Services

Web Development

Digital Marketing

Consumer Tech