synDB Explorer and DROP TABLE

esmondb · 2011-10-18 07:41:44

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 · 2011-10-18 08:59:46

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 · 2011-10-18 09:46:08

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 · 2011-10-18 11:08:15

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

esmondb · 2011-10-18 11:36:45

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

mORMot Open Source

#1 2011-10-18 07:41:44

synDB Explorer and DROP TABLE

#2 2011-10-18 08:59:46

Re: synDB Explorer and DROP TABLE

#3 2011-10-18 09:46:08

Re: synDB Explorer and DROP TABLE

#4 2011-10-18 11:08:15

Re: synDB Explorer and DROP TABLE

#5 2011-10-18 11:36:45

Re: synDB Explorer and DROP TABLE

Board footer