[Axapta-Knowledge-Village] Temporary table
Hi, I've used temp table to store temporary the data before it goes to the printer. My problem is that the generation of the table takes too long aroune 20 minutes. But when I run a stored proce, it takes only less than few 5 minutes. Is Ax temp table really slow ? is there a better way of doing it. I've read about the recordinsertlist but can't quite understand it. can anyone explain in very simple way how it works ? can it replace temp table in report ? thanks, patrick
[Axapta-Knowledge-Village] Temporary Table in report
Hi to All, I'm trying to use a temporary table as data source for my report. However after populating it with the desired data, the report would have no data in it. What I did is to make the temp table as permanent. This time, the report did print ok with the selected customer. My problem is if there are more than 1 user who will print the same report. The problem I foresee is that the selectec customer for first user will be overriden by the second users. This result in an incorrect output. How will I be able to solve this problem? any idea will be greatly appreciated. How come that the temp does not store the data in the report ? regards, Patrick
Re: [Axapta-Knowledge-Village] Temporary Table in report
Hi, Check out this link on temp tables in Reports. http://www.axaptapedia.com/index.php/Temporary_tables There are XPO downloads here. Lemme know if it helped Cheers Arijit http://daxguy.blogspot.com/ On 1/22/07, chuapatrickd [EMAIL PROTECTED] wrote: Hi to All, I'm trying to use a temporary table as data source for my report. However after populating it with the desired data, the report would have no data in it. What I did is to make the temp table as permanent. This time, the report did print ok with the selected customer. My problem is if there are more than 1 user who will print the same report. The problem I foresee is that the selectec customer for first user will be overriden by the second users. This result in an incorrect output. How will I be able to solve this problem? any idea will be greatly appreciated. How come that the temp does not store the data in the report ? regards, Patrick -- Arijit Basu [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Temporary table
I am not sure what you mean by saying that temporary tables are completely local. However, a temporary table is created and exists on the tier where the first insert takes place. This means that if the first insert is on the client that's where the table will be created and remain until it goes out of scope or the user session that creates it is terminated. Likewise, if the first insert is on the server the table will be created and live on the server. Data will only be visible to the session in which the table was created. kumar gaurav [EMAIL PROTECTED] wrote: hi setiaji, The scope of temporary table is completly local. It is intialized the moment you add one record to it and it remains only upto the current procedure is in progress. So there only you can catch the data. Hope it will help, Bye Kumar Setiaji [EMAIL PROTECTED] wrote: Hi,all How can i see records in temporary table while im debugging ? I tried open 2 axapta application in the same time.But still cant see. - setiaji - Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - Varden Morris Senior Developer WellPoint Systems Inc. Microsoft Gold Certified Partner (403) 444-5848 direct (403) 444-3900 main (403) 615-1604 cell www.wellpoint.ca [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
RE: [Axapta-Knowledge-Village] Temporary table
Setiaji, When I need to check that the temp table is indeed loading data as suspected I will set the tables temporary property to false, run the report, and see the data and manually delete the data between runs as I work out any logic issue I may have. Once I'm confident in the logic filling the table, I'll set the property back to temporary on the table. Hope that helps, g'luck -Preston _ From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Setiaji Sent: Thursday, February 09, 2006 3:06 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Temporary table Hi,all How can i see records in temporary table while im debugging ? I tried open 2 axapta application in the same time.But still cant see. - setiaji - Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business http://groups.yahoo.com/gads?t=msk=Business+finance+coursew1=Business+fin ance+coursew2=Business+to+business+financew3=Small+business+financew4=Bus iness+finance+consultantw5=Business+finance+magazinew6=Business+finance+sc hoolsc=6s=185.sig=I8jDsORmsaYn0BeqghcJ2w finance course Business http://groups.yahoo.com/gads?t=msk=Business+to+business+financew1=Busines s+finance+coursew2=Business+to+business+financew3=Small+business+financew 4=Business+finance+consultantw5=Business+finance+magazinew6=Business+finan ce+schoolsc=6s=185.sig=fCzze7cxm1K7TVKkzAaOrA to business finance Small http://groups.yahoo.com/gads?t=msk=Small+business+financew1=Business+fina nce+coursew2=Business+to+business+financew3=Small+business+financew4=Busi ness+finance+consultantw5=Business+finance+magazinew6=Business+finance+sch oolsc=6s=185.sig=v9sWAno7Kz4WuL8Tadcdhw business finance Business http://groups.yahoo.com/gads?t=msk=Business+finance+consultantw1=Business +finance+coursew2=Business+to+business+financew3=Small+business+financew4 =Business+finance+consultantw5=Business+finance+magazinew6=Business+financ e+schoolsc=6s=185.sig=d1xwT3WL0E6XBf6cAV5BXA finance consultant Business http://groups.yahoo.com/gads?t=msk=Business+finance+magazinew1=Business+f inance+coursew2=Business+to+business+financew3=Small+business+financew4=B usiness+finance+consultantw5=Business+finance+magazinew6=Business+finance+ schoolsc=6s=185.sig=qphRINaNuVm_6bwoQxgUmg finance magazine Business http://groups.yahoo.com/gads?t=msk=Business+finance+schoolsw1=Business+fi nance+coursew2=Business+to+business+financew3=Small+business+financew4=Bu siness+finance+consultantw5=Business+finance+magazinew6=Business+finance+s choolsc=6s=185.sig=1RfnhYZpV99RKWRZzSH4gA finance schools _ YAHOO! GROUPS LINKS *Visit your group Axapta-Knowledge-Village http://groups.yahoo.com/group/Axapta-Knowledge-Village on the web. *To unsubscribe from this group, send an email to: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ribe *Your use of Yahoo! Groups is subject to the Yahoo! http://docs.yahoo.com/info/terms/ Terms of Service. _ [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Temporary table
Hi setiaji, On run time after adding data to temporary data use while select on your temp table instance and retrieve the data, you can either store that data in a container or in another table, Hope this will work, for any furthure queries mail me Thanx shivraj Setiaji [EMAIL PROTECTED] wrote: Thx for your immediate answer. How can i catch the data? - setiaji - kumar gaurav wrote: hi setiaji, The scope of temporary table is completly local. It is intialized the moment you add one record to it and it remains only upto the current procedure is in progress. So there only you can catch the data. Hope it will help, Bye Kumar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] Temporary table
Hi,all How can i see records in temporary table while im debugging ? I tried open 2 axapta application in the same time.But still cant see. - setiaji - Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Temporary table
hi setiaji, The scope of temporary table is completly local. It is intialized the moment you add one record to it and it remains only upto the current procedure is in progress. So there only you can catch the data. Hope it will help, Bye Kumar Setiaji [EMAIL PROTECTED] wrote: Hi,all How can i see records in temporary table while im debugging ? I tried open 2 axapta application in the same time.But still cant see. - setiaji - Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. SPONSORED LINKS Business finance course Business to business finance Small business finance Business finance consultant Business finance magazine Business finance schools - YAHOO! GROUPS LINKS Visit your group Axapta-Knowledge-Village on the web. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. - - Jiyo cricket on Yahoo! India cricket Yahoo! Messenger Mobile Stay in touch with your buddies all the time. [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Temporary table
Thx for your immediate answer. How can i catch the data? - setiaji - kumar gaurav wrote: hi setiaji, The scope of temporary table is completly local. It is intialized the moment you add one record to it and it remains only upto the current procedure is in progress. So there only you can catch the data. Hope it will help, Bye Kumar Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Temporary table
Temporary table is alive only where you declared it and on runtime. It means that no data will be seen if you open another instance of anbject( e.g.class that does some calculation) or axapta even more. That's why static methods like Find() on temp tables will not work. The only way is to traverse the temp table by while select --- Setiaji [EMAIL PROTECTED] wrote: Hi,all How can i see records in temporary table while im debugging ? I tried open 2 axapta application in the same time.But still cant see. - setiaji - Paulius Cerniauskas ICQ: 280959446 __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
[Axapta-Knowledge-Village] temporary table
Hi all, I used temp table for report so, If I want to sort and group header at my report (as same normal report ) and I set buffer of this temp but I don't know what I must to do or I must to coding Please, nipnoi Send instant messages to your online friends http://uk.messenger.yahoo.com Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. YAHOO! GROUPS LINKS Visit your group "Axapta-Knowledge-Village" on the web. To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
RE : [Axapta-Knowledge-Village] Temporary table
Thank Varden for the answer. Ashi, what seems to be the problem here? It is working has expected. I've tried that : static void Job1(Args _args){ TmpSum tmpSum, p1, p2; ; tmpSum.Key = 1; tmpSum.insert(); tmpSum.Key = 2; tmpSum.insert(); tmpSum.Key = 3; tmpSum.insert(); p1.setTmpData(tmpSum); p2.setTmpData(tmpSum); while select p1 { //info(p1.Key); while select p2 { info(p1.Key + - + p2.Key); //next p2; } //next p1; } } Steeve... -Message d'origine- De: Ashi Singh [mailto:[EMAIL PROTECTED] Envoyé: 19 février 2005 01:37 À: Axapta-Knowledge-Village@yahoogroups.com Objet: Re: [Axapta-Knowledge-Village] Temporary table Hi Steeve, Once again i am troubling you. But as a Novice to be in Axapta it is a Normal scenarion. to be alaways in Fix. friend as i told you earlier mine problem with movement of Cursor of temporary table . I got a idea from your mail which you have posted. One of your mail response in which you have asked with help of a job that why it's not showing 123123 and showing instead just 123 Then i was thinking that why i should not use the same method in my case that is query_A=new Query(); query_A=element.args().parmObject(); // objSOA_Ash = element.args().parmObject(); objSOA_Ash=element.args().caller().getclassobj(); tmpCustTrans=element.args().caller().gettabledata(); tmpCustTrans1.setTmpData(tmpCustTrans); offCustTrans.setTmpData(tmpcustTrans); //tmpCustTrans1=element.args().caller().gettabledata1(); // offCustTrans=element.args().caller().gettabledata2(); // tmpCustTrans=hello.args().record().dataSource(); Share your views but outrightly the one thing that i am seeing is that during scrolling like while select tmpcusttrans index hint AccountDateIdx where tmpCustTrans.tmpsreDRNo == SalesTable.SalesId { while select tmpcusttrans1 index hint AccountDateIdx where tmpcusttrans1.tmpRecID==tmpcusttrans.tmpRecID { print tmpcusttrans.tmpRecID; print tmpcusttrans1.tmpRecID; } } may have some problem, enrich me with your views . Loooking ahead for your views. Till then bye. Steeve Gilbert [EMAIL PROTECTED] wrote: (See job below) I though I would see in the infolog 1,2,3,1,2,3 but that is not he case, I see 1,2,3. It seems like p1 and p2 use the same cursor for temporary table. Is it possible to browse the same temporary table with different cursor? Steeve static void Job1(Args _args){ TmpSum tmpSum, p1, p2; ; tmpSum.Key = 1; tmpSum.insert(); tmpSum.Key = 2; tmpSum.insert(); tmpSum.Key = 3; tmpSum.insert(); p1 = tmpSum; p2 = tmpSum; select p1; select p2; while (p1) { info(p1.Key); next p1; } while (p2) { info(p2.Key); next p2; } } Steeve... Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: RE : [Axapta-Knowledge-Village] Temporary table
hi steeve , thanking you in first place and i will send a vote of thank to Varden Morris for his timely answer now i hope that both of us are enriched by some little but crucial aspects that do crop up. And a vote thanks to you also for taking so much pain.Now mine report is very near to completion except one thing that i am trying to resolve but not yet successful and that one thing i will also like to share with you though i have posted it on the Axapta village. Nobody knows better than you that i am tryiong to perform a report which have got attached a checkbox on whose status the record will be either printed on the report or not. but now the problem is that as soon as i select any one control all the other checkboxes are also getting selected and vice-versa. though two separate functions which are made as menu items for selecting or deselcting are performing as expected i dont' know why this is happening and trying to solve it. if you have sloution or encountered the similar problem share your views. And make some girl friends so on next Valentine Day you dont' have to play the game in Night. just kidding . Enjoy your life . Keep smiling. Byeee.Steeve Gilbert [EMAIL PROTECTED] wrote: Thank Varden for the answer. Ashi, what seems to be the problem here? It is working has expected. I've tried that : static void Job1(Args _args){ TmpSum tmpSum, p1, p2; ; tmpSum.Key = "1"; tmpSum.insert(); tmpSum.Key = "2"; tmpSum.insert(); tmpSum.Key = "3"; tmpSum.insert(); p1.setTmpData(tmpSum); p2.setTmpData(tmpSum); while select p1 { //info(p1.Key); while select p2 { info(p1.Key + "-" + p2.Key); //next p2; } //next p1; } } Steeve... -Message d'origine-De: Ashi Singh [mailto:[EMAIL PROTECTED] Envoyé: 19 février 2005 01:37À: Axapta-Knowledge-Village@yahoogroups.comObjet: Re: [Axapta-Knowledge-Village] Temporary table Hi Steeve, Once again i am troubling you. But as a Novice to be in Axapta it is a Normal scenarion. to be alaways in Fix. friend as i told you earlier mine problem with movement of Cursor of temporary table . I got a idea from your mail which you have posted. One of your mail response in which you have asked with help of a job that why it's not showing 123123 and showing instead just 123 Then i was thinking that why i should not use the same method in my case that is query_A=new Query();query_A=element.args().parmObject();// objSOA_Ash = element.args().parmObject(); objSOA_Ash=element.args().caller().getclassobj(); tmpCustTrans=element.args().caller().gettabledata(); tmpCustTrans1.setTmpData(tmpCustTrans); offCustTrans.setTmpData(tmpcustTrans); //tmpCustTrans1=element.args().caller().gettabledata1();// offCustTrans=element.args().caller().gettabledata2();// tmpCustTrans=hello.args().record().dataSource(); Share your views but outrightly the one thing that i am seeing is that during scrolling like while select tmpcusttrans index hint AccountDateIdx where tmpCustTrans.tmpsreDRNo == SalesTable.SalesId { while select tmpcusttrans1 index hint AccountDateIdx where tmpcusttrans1.tmpRecID==tmpcusttrans.tmpRecID { print tmpcusttrans.tmpRecID; print tmpcusttrans1.tmpRecID; } } may have some problem, enrich me with your views . Loooking ahead for your views. Till then bye. Steeve Gilbert [EMAIL PROTECTED] wrote: (See job below) I though I would see in the infolog "1,2,3,1,2,3" but that is not he case, I see "1,2,3". It seems like p1 and p2 use the same cursor for temporary table. Is it possible to browse the same temporary table with different cursor? Steeve static void Job1(Args _args){ TmpSum tmpSum, p1, p2; ; tmpSum.Key = "1"; tmpSum.insert(); tmpSum.Key = "2"; tmpSum.insert(); tmpSum.Key = "3"; tmpSum.insert(); p1 = tmpSum; p2 = tmpSum; select p1; select p2; while (p1) { info(p1.Key); next p1; } while (p2) { info(p2.Key); next p2; } } Steeve... Sharing the knowledge on Axapta. Do you Yahoo!?Yahoo! Search presents - Jib Jab's 'Second Term' Sharing the knowledge on Axapta. Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' Sharing the knowledge on Axapta. Yahoo! Groups Sponsor Get unlimited calls to U.S./Canada Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Temporary table
(See job below) I though I would see in the infolog 1,2,3,1,2,3 but that is not he case, I see 1,2,3. It seems like p1 and p2 use the same cursor for temporary table. Is it possible to browse the same temporary table with different cursor? Steeve static void Job1(Args _args){ TmpSum tmpSum, p1, p2; ; tmpSum.Key = 1; tmpSum.insert(); tmpSum.Key = 2; tmpSum.insert(); tmpSum.Key = 3; tmpSum.insert(); p1 = tmpSum; p2 = tmpSum; select p1; select p2; while (p1) { info(p1.Key); next p1; } while (p2) { info(p2.Key); next p2; } } Steeve... Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Temporary table
Hi After populating tmpSum you do the following: p1.setTmpData(tmpSum); p2.setTmpData(tmpSum); That should do he trick. Varden Steeve Gilbert [EMAIL PROTECTED] wrote: (See job below) I though I would see in the infolog "1,2,3,1,2,3" but that is not he case, I see "1,2,3". It seems like p1 and p2 use the same cursor for temporary table. Is it possible to browse the same temporary table with different cursor? Steeve static void Job1(Args _args){ TmpSum tmpSum, p1, p2; ; tmpSum.Key = "1"; tmpSum.insert(); tmpSum.Key = "2"; tmpSum.insert(); tmpSum.Key = "3"; tmpSum.insert(); p1 = tmpSum; p2 = tmpSum; select p1; select p2; while (p1) { info(p1.Key); next p1; } while (p2) { info(p2.Key); next p2; } } Steeve... Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Re: [Axapta-Knowledge-Village] Temporary table
Hi Steeve, Once again i am troubling you. But as a Novice to be in Axapta it is a Normal scenarion. to be alaways in Fix. friend as i told you earlier mine problem with movement of Cursor of temporary table . I got a idea from your mail which you have posted. One of your mail response in which you have asked with help of a job that why it's not showing 123123 and showing instead just 123 Then i was thinking that why i should not use the same method in my case that is query_A=new Query();query_A=element.args().parmObject();// objSOA_Ash = element.args().parmObject(); objSOA_Ash=element.args().caller().getclassobj(); tmpCustTrans=element.args().caller().gettabledata(); tmpCustTrans1.setTmpData(tmpCustTrans); offCustTrans.setTmpData(tmpcustTrans); //tmpCustTrans1=element.args().caller().gettabledata1();// offCustTrans=element.args().caller().gettabledata2();// tmpCustTrans=hello.args().record().dataSource(); Share your views but outrightly the one thing that i am seeing is that during scrolling like while select tmpcusttrans index hint AccountDateIdx where tmpCustTrans.tmpsreDRNo == SalesTable.SalesId { while select tmpcusttrans1 index hint AccountDateIdx where tmpcusttrans1.tmpRecID==tmpcusttrans.tmpRecID { print tmpcusttrans.tmpRecID; print tmpcusttrans1.tmpRecID; } } may have some problem, enrich me with your views . Loooking ahead for your views. Till then bye. Steeve Gilbert [EMAIL PROTECTED] wrote: (See job below) I though I would see in the infolog "1,2,3,1,2,3" but that is not he case, I see "1,2,3". It seems like p1 and p2 use the same cursor for temporary table. Is it possible to browse the same temporary table with different cursor? Steeve static void Job1(Args _args){ TmpSum tmpSum, p1, p2; ; tmpSum.Key = "1"; tmpSum.insert(); tmpSum.Key = "2"; tmpSum.insert(); tmpSum.Key = "3"; tmpSum.insert(); p1 = tmpSum; p2 = tmpSum; select p1; select p2; while (p1) { info(p1.Key); next p1; } while (p2) { info(p2.Key); next p2; } } Steeve... Sharing the knowledge on Axapta. Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term' Sharing the knowledge on Axapta. Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Axapta-Knowledge-Village] Temporary Table cannot be set for security setup
Hi All, I tried to configure user security for calling some menus and allow user only to access limited tables. After a while, I configured for GL | Reports | Reconciliation | Inventory Report. I open security type for 'Main Menu', then configure view access for that report. The problem is, when I logged-in using the user with view access for that report, it showed: Unable to run InventLedgerConciliation due to access restriction in table TmpInventBalance. It seems that TmpInventBalance has 'InventTable' security key. But, when I try to open security setup for 'Security Key', I couldn't find Inventory management | Tables | 'Item posting' table (which is TmpInventBalance). When I debug the code, at SysSecurity class of expandSecurityKey method, Line 123, the method will check if the table is allowed or not for security setup. if (table.dataId == tableNum(TmpInventBalance)) //534 breakpoint; dictTable = new SysDictTable(table.dataId); if (!dictTable.allowSecuritySetup()) continue; At allowSecuritySetup method, it checks that if it is temporary table, then it won't shown. boolean allowSecuritySetup(){ if (this.isTmp() || this.isMap() || this.isView() || this.id() == tableNum(AccessRightslist) || this.id() == tableNum(SysConfig) || !this.securityKeyId() || //If not, the table rights cannot be calculated if the user is a member of 1 group (this.configurationKeyId() !isConfigurationkeyEnabled(this.configurationKeyId( return false; return true;} So, what can I do to configure TmpInventBalance table security, then the user will be able to run the report ? Many thanks, Sonny Wibawa Adi Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. Sharing the knowledge on Axapta. Yahoo! Groups Sponsor ADVERTISEMENT Yahoo! Groups Links To visit your group on the web, go to:http://groups.yahoo.com/group/Axapta-Knowledge-Village/ To unsubscribe from this group, send an email to:[EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.