1. B M
  2. Valentina Studio
  3. Tuesday, March 26 2019, 04:08 AM
  4.  Subscribe via email
I have a question related to VS Pro 9.1. I do not recall if this was the same behavior in previous versions but here it goes: I wan to create a form based on a view. Once the form is created, I want to designate a text field to be a "Filter and Apply" (so I can search the data). However, after executing the form and trying to type in a criteria, an error occurs. See attached screenshot.

Question: does "Filter and Apply" "Data Mode" method works only on tables?
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hello,

There is a semicolon at the end, so it can't be used as a subquery:
select * from utilities.v_expenditure;

Did you create a query for selecting data from the view?
When I set a view as a source - it generates a query without the semicolon, so filtering works.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
B M Accepted Answer
Hello,

There is a semicolon at the end, so it can't be used as a subquery:
select * from utilities.v_expenditure;

Did you create a query for selecting data from the view?
When I set a view as a source - it generates a query without the semicolon, so filtering works.



Thanks Sergey. That was it (semi colon in a view I was pointing to). Question, is there a documentation somewhere that would show me how to set a sort field on the form? I can do majority with query pre-sorting but that adds to time. Having ability to "sort" filtered data would be much quicker.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Sergey Pashkov Accepted Answer
Sorting will be available in the next version.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories