mibuso.com

The SourceTableTemporary is a new property introduced in 5.0 giving all kinds of new capabilities of showing data that is not even in the database.

Instead of showing real data from the database, the form is running on an empty table when starting up, so you will have to populate it with data.

Step 1.

Create a normal form with the wizard and define your sourcetable. Select the columns you want to (ab)use.

Make sure to select the SourceTableTemporary property.

In our example we will use table 18, Customer and select columns No. and Name.

Step 2.

Create a new function "InitTempTable"

In this function define a Local variable "Cust", type Record, Subtype 18. (Customer).

Write the following piece of C/AL Code



Step 3

Go to the OnOpenForm trigger and put the new function in there.

Result

A view of your customers with a filter that is normaly not possible with the normal filters still available.

The idea and example are from form 634 Chart of Accounts Overview in 5.0. You'll also find a great example there of how to expand and collapse.

For a customer I've built a view combining 2 tables based on a date filter with quantities summed up from other tables. It is very easy to use and setup and when using proper indexing the performance is perfect.

Good luck.

Nice meeting you.

This is Kiran. I have verified in my database with hotfix nav5.00 the form property you specified 'sourcetabletemporary' . But, I did't get that in my database version 4.00 SP3.

Let please know to me about the Property with any .fob file.

Kiran.

As Mark already explained, this property is only available starting from Dynamics NAV 5.0.

You can run similar funcionality in 4.x but you have to:

1. Create variable based on record of your interest
2. Set the TEMPORARY property of variable to YES
3. Fill temporary variable with data
4. Run the form using syntax:



Regards,
Slawek

You are right, to be found in codeunit 1 function SetGlobalLanguage

Some additional info:

Of course if you don't want to hardcode the filters you'll need to DELETEALL and re-populate the temp table. But the problem is that some genius might change SourceTableTemporary to NO and boom, your table is nuked, hope you have a backup from yesterday. So IMHO you should never DELETALL a temporary table. In the usual cases you can solve it by making it local to a function but not in this case. So what to do? My solution is to use a processing-only report where the user can set the filters the usual way, then the report will populate the temp table and run the form on it. No further processing on the form therefore no need to DELETEALL.

Deleting Records:

So I was using this property for the first time today and found out a bit of an issue with deleting.

When you delete a temporary record it runs all the code on the delete trigger of the record. So in my case the form was bases on the item table, when I deleted the temporary record it didn't delete the actual item record but it did delete any related data. So in my test case it deleted all the comments associated with the item.

To stop this I put the following code on the form:
Form - OnDeleteRecord() : Boolean
DELETE(FALSE);
EXIT(FALSE);

I think that's ok, if someone has a better solution please let me know

be aware that the same does happen for other triggers,too (validates, insert, modify...)

sorry, i didn't get you ...is it a question?if so, can you explain it in detail, please?

I do it the same way, but i've got a small (probably big) problem: i have to call some functions before running the form (page in my case, but it's not important), thus i have to declare the form as a variable in order to call the functions and run the form with the same instance...i still can't find a proper function to set a temptable variable as the form variable sourcetable:
settableview --> useless, it just sets the filters
setrecord --> useless, it just sets the "focus"
any idea?am i missing some parameter, maybe?
Thanks in advance

F**k off!!(sorry, but i'm really disappointed)i guess i can't
http://www.mibuso.com/forum/viewtopic.php?f=23&t=38328

Little trick to send parameters to a form even if you use FORM.RUNMODAL or FORM.RUN.

-create a singleinstance codeunit with 2 functions: "SaveInfo" and "GetInfo".

Before running FORM.RUNMODAL, run the function "SaveInfo" in which you pass your parameter you want to give to the form
In the OnOpenForm of your form, run function GetInfo that returns the parameter you just saved in the SingleInstance codeunit.

I use this technique VERY often.

OMG!!!
You're OUTSTANDING!

He He just a busy day for spammers today.

if you want to send parameter to a form just take a variable type FORM and create a function in form to be run, before running form call this function and you can send parameter to form.
in this case form also holds values given by report.