nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Query Builder - Saving Data Table

nick_shelton

Hi All,

Does anybody know if it's possible using the "Save Table" option in Query Builder to overwrite an exisiting data table? "Save Table" will allow you to save a data table back into the DB but I receive an alert message when I want to re-save a data table which already exists in the DB. I don't know if that's a limitation of the example Jumanji connection config settings or if it's related to JMP. Your help is appreciated.

JMP_Alert.jpg

Accepted answers

briancorcoran

You can try that. You may have a permissions issue that will block that as well.

All comments

briancorcoran

Save Table issues a warning because it is going to issue a Drop Table command, which for a DB is regarded as a high risk operation. This means the table is deleted before the new table is saved, so there is no unwinding of the transaction. There is no way to suppress this warning. I imagine you could use Custom SQL in Query Builder or the JSL Execute SQL to circumvent this and "roll your own", but I would not recommend that.

Brian Corcoran

nick_shelton

Thanks Brian, In my case the updated table does not save back into the database after the alert is given. But based off of your reply I can use the drop table option to delete the table from the DB and then use the save table option as a workaround.

briancorcoran

You can try that. You may have a permissions issue that will block that as well.

nick_shelton

You're right, the request to drop the table was blocked. That's fine, I will tell the customer he needs to have the correct file permissions in order to overwrite an existing table, thanks.