mORMot Open Source

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

synDB Explorer and DROP TABLE

After executing a 'DROP TABLE' command in synDB Explorer (sample 12) the list of tables doesn't update so you subsequently get errors clicking on them. (low priority issue)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,667

Website

Re: synDB Explorer and DROP TABLE

You are right.

You'll have to open the corresponding database connection settings at next SynDbExplorer startup, in order to retrieve the list of tables.
In fact, the table list is stored in cache if the connection settings are not displayed (it speeds up the loading a lot with huge databases).

I may parse the SQL executed to refresh it, or add an explicit 'Refresh DB layout' content in the main screen (or a right-click popup menu).
What do you think would be preferred?

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

Re: synDB Explorer and DROP TABLE

Parsing would be nicer. I guess you would only need to look for 'DROP TABLE' and 'CREATE TABLE' but I'm not sure how trivial that would be to implement reliably. I would be happy with a 'refresh' button too.

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,667

Website

Re: synDB Explorer and DROP TABLE

What may be good with the "refresh" button is that external software (including our framework) may have modified the database structure.

esmondb

Member

From: London

Registered: 2010-07-20

Posts: 299

Re: synDB Explorer and DROP TABLE

Good point, sounds like a "refresh" button would be best.