Table Remote Info (Python)¶
Table Remote Info (Python)¶
1ot = impact.gui.output_toolbox
2
3ot.clear()
4db = impact.active_database
5tbl = None
6try:
7 tbl = db.settings.tables.item("GRADES")
8except Exception as exc:
9 impact.gui.output_toolbox.add(f"Failed to create object via db.settings.tables.item(): {exc}")
10
11if not (tbl.isNone()) and (tbl.type == ipDatabaseTableType.dttRemote):
12
13 ot.add("Located remote table '" + tbl.name + "'")
14
15 if not tbl.remote_index.isNone():
16
17 ot.add("Remote Index Column: " + tbl.remote_index.name)
18 ot.add("Auto Increment values: " + str(tbl.remote_auto_increment))
19 ot.add("Row Zero Locking: " + str(tbl.remote_row_zero_locking))
20
21else:
22
23 ot.add("Unable to find remote table 'GRADES'")