Example 16: why I not see the list of tables of *.sqlite file?

corchi72 · 2013-02-15 13:35:11

I can not see the list of tables in a Database generated with mMormot Framework.

Thanks corchi

ab · 2013-02-15 14:10:51

No problem from here, compiled with Delphi 7.

corchi72 · 2013-02-15 14:13:05

I compiled with Delphi XE2 update 4

Synopse framework 1.18

SQLite3 engine 3.7.15.2

Last edited by corchi72 (2013-02-15 14:24:47)

ab · 2013-02-15 15:26:40

Do simple SELECT commands work?

Are you sure you are pointing to the right .sqlite file?

corchi72 · 2013-02-15 15:46:32

The path to the *. Sqlite is correct, but I can not do any query, I left the server name white,and I filled in all the other fields, Admin, synopse.

I have noticed that I only sqliteadmin using the system table sqlite_sequence and I do not see sqlite_master, while if I use pro sqlite2009 see both the system tables.
What do you think?

esmondb · 2013-02-15 17:27:49

I've just tried it and it works for some tables but not for others in XE2. The AuthGroup table shows fine but Users table gives this exception:

Project Project16Client.exe raised exception class EInterfaceFaceFactoryException with message 'Invalid fake IRemoteSQL.Execute interface call:'.

ab · 2013-02-15 22:03:18

Yes, there is an issue with the new RawJSON kind of parameter.

I'll fix it ASAP, and add some regression tests.

ab · 2013-02-16 12:16:20

Issue should be fixed by http://synopse.info/fossil/info/e40d9d5a49

I've tested it with Delphi 7 and XE2, and works as expected.

@corchi: to use SQLite3 engine, follow the TSQLDBSQLite3Properties.Create pattern, i.e. put the DB file name as server name, and leave other fields blank.

corchi72 · 2013-02-18 08:47:36

ok, I just tested the fix and it works fine!!
thanks

mORMot Open Source

#1 2013-02-15 13:35:11

Example 16: why I not see the list of tables of *.sqlite file?

#2 2013-02-15 14:10:51

Re: Example 16: why I not see the list of tables of *.sqlite file?

#3 2013-02-15 14:13:05

Re: Example 16: why I not see the list of tables of *.sqlite file?

#4 2013-02-15 15:26:40

Re: Example 16: why I not see the list of tables of *.sqlite file?

#5 2013-02-15 15:46:32

Re: Example 16: why I not see the list of tables of *.sqlite file?

#6 2013-02-15 17:27:49

Re: Example 16: why I not see the list of tables of *.sqlite file?

#7 2013-02-15 22:03:18

Re: Example 16: why I not see the list of tables of *.sqlite file?

#8 2013-02-16 12:16:20

Re: Example 16: why I not see the list of tables of *.sqlite file?

#9 2013-02-18 08:47:36

Re: Example 16: why I not see the list of tables of *.sqlite file?

Board footer