Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
Add a reply View Replies (5)

Resolved Existing SQLite database : Missing fields in tables with VS

  1. Fabrice Dejaigher
    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 ?
  1. Valentina Studio
  2. DB_SQLITE
  3. Bug?
Comment
There are no comments made yet.
Responses (5)
Sergey Pashkov
Sergey Pashkov Accepted Answer
Hello Fabrice,

Could you please show the Query property value of the table12?
Attachments (1)
Screenshot 2019-05-21 15.24.18.png Screenshot 2019-05-21 15.24.18.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Fabrice Dejaigher
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)
Sélection_108.png Sélection_108.png
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Sergey Pashkov
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.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Fabrice Dejaigher
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.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
Igor Nikitin
Igor Nikitin Accepted Answer
Fixed, the fix will available into the next release.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 5
  • Page :
  • 1


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