i was wondering if anyone experienced time outs while running a long query or stored procedure using a macro?
i noticed that a grid app has a time out setting. so there is a something to set it up.
however if you use SC_LOOKUP macro you might get over timeout. In my case, the called procedure just brakes, doing only the first part of the sql script. i notice it works up to 40 sec, but if you wait longer , SC_LOOKUP will brake. also sc_exec_sql($update_sql);