var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Disable trigger from 4gl
I am trying to disable all the triggers of a table before updating some records. This is my code:
I get the following error:
prepare s_trigger_off from "set triggers for table disabled"
prepare p_stmt from stmt
prepare s_trigger_on from "set triggers for table enabled"
Any ideas what I am doing wrong?
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.
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.
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
Originally Posted by Luis Santos