I want to create some tables in database when new user is added using ‘User Management’ component. These tables will hold data for that particular user. As per manual, “extension function onUserSave() of ‘User Management’ is called when the save button is pressed when adding or editing a role. This code is executed in a background thread”. So I wrote
system.db.runPrepUpdate("CREATE TABLE ? (Name VARCHAR(100) NOT NULL)", [tableName]) in this function, but it threw error. Is this because, “The “?” placeholder cannot reference column names, table names, or the underlying syntax of the query”
Is there any way I can add tables using code in background on new user addition?