1. Fabrice Dejaigher
  2. Valentina Studio
  3. Вторник, Май 21 2019, 11:53 AM
  4.  Подписаться через 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 ?
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Fabrice,

Could you please show the Query property value of the table12?
Вложения
Комментарий
There are no comments made yet.
Fabrice Dejaigher Ответ принят
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)
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Thank you, reproduced the problem - NOT NULL is not recognized after constraint.

Created the mantis ticket.
Ссылки
  1. http://valentina-db.com/bt/view.php?id=8537
Комментарий
There are no comments made yet.
Fabrice Dejaigher Ответ принят
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 !
Комментарий
There are no comments made yet.
Igor Nikitin Ответ принят
Fixed, the fix will available into the next release.
Комментарий
There are no comments made yet.
  • Страница :
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories