ajax events

Applications Grid / Reports
#1

hi
i have this problem

in a field of a grid I added a ajax onclick evnet that contine the following functions:
sc_commit_trans (“connessione”);
sc_exec_sql (“UPDATE doc_container SET published = 2 WHERE id = {id}”);

sc_redir (http://www.xxx.dyndns.xxx/xxxxx/documenti.php?f1 dmfilename = {id});

the sql is never executed is that a bug?

thnks

#2

Put some trace messages to look. I.e. it might be WHERE id=’{id}’. Or perhaps you need a commit trans after the update. If you do a sc_redir the automatic commit of SC is not executed.

#3

insert in the sql is correct I tried.
is a grid with ajax on click is possibile to use sc_exec_sql and sc_redir