1. Kevin
  2. Valentina Studio
  3. Friday, July 24 2020, 01:44 PM
  4.  Subscribe via email
Studio Pro 10.4.12
SQLite
Windows 10

I created a View. During the process of creating a form based on the View, the View is present, I can select the View; however, none of the fields in the View appear in Available Fields to select. Thus, I can't proceed.

Am I missing step?

Thank you.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Kevin,

Yes, something wrong with the SQLite datasource, the fields are not loaded for views in the wizard.

While we're fixing it, the fastest workaround is to create a form for table and then switch to the view in the Records list, remove wrong fields and drag this view to the form.
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello Kevin,

SQLite views in the Form Wizard are fixed in 10.4.18
Comment
There are no comments made yet.
  1. one week ago
  2. Valentina Studio
  3. # 2
Kevin Accepted Answer
Hi Sergey,

I just tried this in 10.4.18 and I am still not seeing the fields. Does the view require a trigger? Mine does not.

(The workaround works.)

Kevin
Comment
There are no comments made yet.
  1. one week ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
Hi Kevin,

No, the trigger is not necessary, sorry, one more change needed.
Comment
There are no comments made yet.
  1. one week ago
  2. Valentina Studio
  3. # 4
  • 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. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories