1. Kevin
  2. Valentina Studio
  3. Freitag, Juli 24 2020, 01:44 PM
  4.  Abonnieren via E-Mail
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Kevin,

SQLite views in the Form Wizard are fixed in 10.4.18
Kommentar
There are no comments made yet.
Kevin Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hi Kevin,

No, the trigger is not necessary, sorry, one more change needed.
Kommentar
There are no comments made yet.
  • Seite :
  • 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