1. Fabrice Dejaigher
  2. Valentina Studio
  3. Tuesday, May 21 2019, 11:53 AM
  4.  Subscribe via email
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 ?
Comment
There are no comments made yet.
Igor Nikitin Accepted Answer
Fixed, the fix will available into the next release.
Comment
There are no comments made yet.
Fabrice Dejaigher Accepted Answer
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 !
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Thank you, reproduced the problem - NOT NULL is not recognized after constraint.

Created the mantis ticket.
References
  1. http://valentina-db.com/bt/view.php?id=8537
Comment
There are no comments made yet.
Fabrice Dejaigher Accepted Answer
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)
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Fabrice,

Could you please show the Query property value of the table12?
Attachments (1)
Comment
There are no comments made yet.
  • Page :
  • 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