How to put records in a table box

deepblue

Hello,

I have a table with fields that have as source expression variables and are not related to any tables. I need to put in it records that are located in a table and selected by a specific filter!!! How can I do it?

Thank you!!!

kriki

Can you be more clear?

deepblue

Ok Kriki, i will try to be more clear!

I'm trying to put records in a table-box. In this table box the source expression of the fields are global variables and not fields from tables.

The records I'm trying to inset into the table box are selected from a table using some filters.

How can I do it?

Thank you!

kriki

There are 2 parts in what you want to do:

1) you want to select some records to use in the tablebox
2) you want some calculated fields to show in the tablebox

Lets start on how to solve them:
1) Can you just put a filter on it to show the records you want?
If not, put the records you want in a temptable in run the form like this:

FORM.RUNMODAL(FORM::"Your Form",tmpTheTempTable);

This gives the form normal filtering possibilities to the user.

2) in case you use a temptable in point 1: can you use the fields to show the values (even calculated)? In this case when filling the temptable, you can also fill the fields in the temptable and you don't have to use global variables. This is better for the DB because the values are only calculated once and not on every refresh of the records in the tablebox.
If not, you have to put the code to calculate the global fields in the tablebox in the "OnAfterGetRecord" of the form.