mORMot Open Source

ebz

Member

Registered: 2011-07-20

Posts: 18

Export some tables failed using SynDB Explorer

I tried open dbdemos.db3 sample database from SQLite Expert Personal. Database was opened successfully, there are 21 tables, one (last) table fail to read because using unicode as a name (synDB explorer using string as table name).
Export 2 tables below also failed:

• biolife : 'duplicate column name:Species'

• custoly: 'near "/": syntax error

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,205

Website

Re: Export some tables failed using SynDB Explorer

I just opened the DB with SynDBExplorer compiled with Delphi XE3.
With the latest version from http://synopse.info/fossil/wiki?name=Get+the+source

No problem with the unicode names.

Of course, the GUI part of SynDBExplorer may have problems when compiled with pre-Unicode version of Delphi.
But this is not due to the SynDB*.pas layer, which is perfectly Unicode ready (UTF-8).
It is due to the VCL itself.

ebz

Member

Registered: 2011-07-20

Posts: 18

Re: Export some tables failed using SynDB Explorer

Oh great..
How about error in export the two tables ?

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,205

Website

Re: Export some tables failed using SynDB Explorer

I did not check this.

Which kind of export?

ebz

Member

Registered: 2011-07-20

Posts: 18

Re: Export some tables failed using SynDB Explorer

"Tables Export" button