1. Fabrice Dejaigher
  2. Valentina Studio
  3. 火, 5月 21 2019, 11:53 AM
  4.  メールで購読
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