1. Fabrice Dejaigher
  2. Valentina Studio
  3. Dienstag, Mai 21 2019, 11:53 AM
  4.  Abonnieren via E-Mail
I tried Valentina Studio Free (both on Mac and Linux), with an existing sqlite database but I have some problems with missing fields.

For example :

What is created and OK in other DB Tools :

table1
idtable1
field1
field2

table2
idtable2
field1
field2

table12
idtable1
idtable2

In VS table1 and table2 seem OK but table12 show no field, or only one.

I created this database with SQLite Studio, I also open this database with DBeaver, DB Browser for SQLite and DBVisualizer and all tables are OK.

So what's wrong with Valentina Studio ?
Kommentar
There are no comments made yet.
Igor Nikitin Akzeptierte Antwort
Fixed, the fix will available into the next release.
Kommentar
There are no comments made yet.
Fabrice Dejaigher Akzeptierte Antwort
Hello Sergey,

Thanks for your answer and so rapidly !
It's really a good job ;)

I'll be happy to test as soon as update will be available. :)

Have a nice day !
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Thank you, reproduced the problem - NOT NULL is not recognized after constraint.

Created the mantis ticket.
Referenzen
  1. http://valentina-db.com/bt/view.php?id=8537
Kommentar
There are no comments made yet.
Fabrice Dejaigher Akzeptierte Antwort
Hello Sergey,

Screenshot joined and query looks good :


CREATE TABLE z_etiquette_lieu (idetiquette INTEGER REFERENCES etiquette (idetiquette) NOT NULL, idlieu INTEGER REFERENCES lieu (idlieu) NOT NULL)
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Fabrice,

Could you please show the Query property value of the table12?
Anhänge
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories