system.db.runNamedQuery [tx] syntax

[pturmel]

1. Well, it isn't convenient:

Getting the context in which a function is running?

However you check for scope, consider doing it at the top level of an inherited script module, setting booleans like isDesigner and isGateway. Then just check the booleans everywhere else. Something like this: try: isDesigner = bool(system.util.getSystemFlags() & system.util.DESIGNER_FLAG) isGateway = False except AttributeError: isDesigner = False isGateway = True

2. system.project.getProjectName()

3. Depends on your JDBC driver and primary key column type(s).