1. Kevin
  2. Valentina Studio
  3. Saturday, February 27 2021, 09:25 PM
  4.  Subscribe via email
Hi,

My main form is based on a table (tbl_Transactions).

The form contains a TableView based on a query (qry_Transactions).

The form contains two comboBoxes. Each contains a different query. Both queries are based on fields in the tbl_Transactions table.

The form's purpose: a complex filter. (Thank you for the Simple and Complex Filter tutorials!)

The form works, but I am confused on a few things.

The Query, Records, Table, and View Templates folders contain similar templates (Add Filter, Apply Filters, ...). Which one do I choose? More than one?

If one's main form is based on a table, does one use the Table Templates folder or the Records Templates folder? Or, using the example above, the main form is based on a table and the form includes a TableView based on a query, which one does one choose? Or is this a case one needs this Templates folder for these types of actions and one needs that Templates folder for those types of actions.

Thanks,

Kevin
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Hi Kevin,

All of these templates are applied to the cursor based on the source object of the form.
In case of the TableView, it is necessary to filter records of this TableView itself, e.g.:


r = this.TableView.records;
r.addFilter( 'amount < 2' );
r.applyFilters();

this.TableView.records = r;


For now, the last row is necessary for the update of the TableView.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Kevin Accepted Answer
Sergey,

Thank you and thank you for the example!

Kevin
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
  • 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