mibuso.com

i know, but form variables cannot be used for my specific problem: you probably miss my previous posts, this:

AND this:

as explained in the whole topic, temptables can be passed as source only with FORM.RUN(tableno,mytemptable) syntax and not with myformvariable.run
This means that i cannot use form variables, and then i can (and do) use kriki's suggestion.
P.S.: as expected, it works like a charm , i could finally remove those system fields i put in the table just to have their value...
i created a monster form, i'll post some code snippets about it when i'll have some times...
it's a form + subform with both header and lines as temporary tables populated from a report. There are also some variables "as fields" in the subform.

I use a different technique to solve Belias problem.

Add a function to form (page) (the form (page) that use temporary table) like this:

GetTempTable(VAR : Record TableName)
TableName.COPY(Rec.TRUE);

Tablename is the same of Rec of the Form/Page.
Function parameter is passed by VAR and the record is of the same type of form (page) Rec.
Notice parameters is NOT defined as temporary. Notice also i use paremater TRUE in COPY function (this is a very useful option in COPY functions!)

I define a form (page) variable in a codeunit or in another form (page)
Name DataType Subtype Length
FormwithTemporaryrec Form Item Journal

From the form/page/codeunit a call the function
FormwithTemporaryrec.GetTempTable(X)

X ia a variable of type rec, subtype the sabe of Rec of FormwithTemporaryrec
X is defined as Temporary

After this call you cal use X variable (you can insert records).
If you open the form with
FormwithTemporaryrec.RUNMODAL,
the form will show the record you inserted in calling form/page/codeunit.

Great! this is even better than the singleinstance codeunit!
I've always underestimated the COPY function...thanks a lot!

with respect,
As my above post when i am sending parameter to form by function then why can't we send Rec type parameter even if we have to set it Call by Var.

Can you write the exact code you would have written, please? probably it's just mine misunderstanding of your post

before....
FormwithTemporaryrec.GetTempTable(Par1,par2)
now instead of this....


where Rec is call by var in function

WOW! I just learned something new! I never noticed the second parameter in the copy-functions!

I just checked a moment and the second parameter exists only form NAV2009! It doesn't exist in 5.0SP1!

comment....
If ShareTable is true, both Record and FromRecord must be temporary; otherwise an error will occur.

Here you are a sample on how to use the sharetable parameter as suggested by stevedivimast
(copy and paste the code in a text object: pages 50003 & 50004)

this example is really stupid, but interesting because it shows how powerful is this function if you want to determine the behaviour of factboxes, too.

Remark: i noticed a small drawback of the sharetable method VS the singleinstance method: if you have a page that has NOT the sourcetabletemporary property set to yes, in order to use the sharetable method you have to replicate the same page, and set the sourcetabletemporary to yes. Otherwise the copy function will return an error, as expected.

t's also possible in a Page with a temporary Rec to change "dinamically" the Rec Itself.

To do this add a function to this page like this:

ChangeTmpRec(VAR TableName : TEMPORARY Record Item)
Rec.COPY(TableName,TRUE);
EXIT;

Please, notice the sharetable parameter in COPY function.
Then if you use a Page Variable (in a page or in a codeunit) you can do this:

PageVar.ChangeTmpRec(TempItemVar)
PageVar.RUN (or RUNMODAL)

(TempItemVar is defined as Record Item Temporary)

The page will use TempItemVar instead of original Page Rec.
Tested in Nav2009 and NAv2009Sp1)

This technique is similar to that one on my previous post.
In this case i "tell" to tha page the temporary record to use, in the previuos one I "ask" to the page the teporary recor it uses.

If you try to use this technique with a form you get a very strange behavior:
The first time you open the form it work fine. The second one will crash Navision (you have to restart).
I sended this error to Miscosoft people.

To have the same functionality for RTC PAge, then what can be done?
For your information, replacing just FORM to PAGE is not working in above code.

Please, suggest.

I am trying to do this with a ListPart Page in NAV 2009 R2 but nothing seems to work. I want a FactBox with a calulated number of lines based on the line that is being filtered. Think about this example as if I was pulling the top 5 customers around the customer that is chosen.

An old post... but did you have any sucess with this? We want to do a similar thing too.

cheers, Tim

some builds in the NAV R2 fires the onaftergetrecord trigger unexpectedly.
e.g.: you open the page and the client fires the onaftergetrecord trigger like an heavy machine gun (ref. metal slug ), then the trigger is not fired anymore when you browse through records.
Try with the last build.

Thanks for the heads up on that one. I've seen it doing strange things already. I don't think it will solve my requirement of having a factbox update against a list part line though as we can't know what the current record is. We could do with the "OnAfterGetCurrRecord" trigger back.