show triggers
show_qry("triggers", TRIGGERS_INFO_SQL)
print("\n\n")
print("--- %s ---" % "triggers bodies")
querystr1 = SELECT trigid, tabname, trigname
FROM systables, systriggers
WHERE tabtype="T"
AND systables.tabid >= 100
After Change
def show_triggers():
show triggers
show_qry("triggers", TRIGGERS_INFO_SQL)
title = "triggers bodies"print_start_info(title)
querystr1 = SELECT trigid, tabname, trigname
FROM systables, systriggers
WHERE tabtype="T"
AND systables.tabid >= 100
AND systables.tabid = systriggers.tabid
ORDER BY tabname, trigname
querystr2 = SELECT data FROM systrigbody
WHERE trigid=%s
AND (datakey = "D")
ORDER BY seqno
querystr3 = SELECT data FROM systrigbody
WHERE trigid=%s
AND (datakey = "A")
ORDER BY seqno
rs = select_qry(querystr1)
if rs:
for row in rs:
trigname = "trigger %s" % (row[2])
trigid = row[0]
for row in rs:
body_def = get_body(querystr2 % trigid)
body_txt = get_body(querystr3 % trigid)
output_line("\n\n -- >>> %s >>> --" % trigname)
output_line(body_def)
output_line(body_txt)
output_line("\n\n -- <<< %s <<< --" % trigname)
print_stop_info(title)
def get_info_filter():
result = ""
