mORMot Open Source

array81

Member

From: Italy

Registered: 2010-07-23

Posts: 411

Problems with TSQLModel

Hi,

in the last 2 days I have add a new table on my database, so I have create the new TSQLRecord class then I have change my TSQLModel. I have recompile my application and open my database. In this way the framework must add the new table (I just do it in the past).

However there are some problem. I have open the database with your official editor because I need create a new query with the new table. I cannot find the table on the tables list!, If I try to run "select * from AgendaAllarms" (AgendaAllarms is the new table) I can see the table structure as result, so the table was created but I cannot see it on table list. I also try to open my database with another editor, same result.

Do you have some ideas?

regards

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Problems with TSQLModel

Does your server side code call CreateMissingTables() method?

array81

Member

From: Italy

Registered: 2010-07-23

Posts: 411

Re: Problems with TSQLModel

Yes, CreateMissingTables is call. In fact if I call "select * from AgendaAllarms" I can see all table fields...

I have try to open my db with this sqlite editor http://sqliteadmin.orbmu2k.de/, with it I can see the new table on tables list. But with your editor and also with other commercial tool I cannot see it.

Ideas?

Last edited by array81 (2012-02-06 20:37:25)

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,660

Website

Re: Problems with TSQLModel

Please note that SynDBExplorer uses an internal cache for the table list.

You'll have to explicitly check "Update connection settings" at SynDBExplorer startup to refresh the list on screen.