[Axapta-Knowledge-Village] Temporary table

2007-01-26 Thread chuapatrickd
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

[Axapta-Knowledge-Village] Temporary Table in report

2007-01-21 Thread chuapatrickd
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

Re: [Axapta-Knowledge-Village] Temporary Table in report

2007-01-21 Thread Arijit Basu
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

Re: [Axapta-Knowledge-Village] Temporary table

2006-02-09 Thread Varden Morris
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

RE: [Axapta-Knowledge-Village] Temporary table

2006-02-09 Thread Preston A. Larimer
@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

Re: [Axapta-Knowledge-Village] Temporary table

2006-02-09 Thread raj verma
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

[Axapta-Knowledge-Village] Temporary table

2006-02-08 Thread Setiaji
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

Re: [Axapta-Knowledge-Village] Temporary table

2006-02-08 Thread kumar gaurav
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]

Re: [Axapta-Knowledge-Village] Temporary table

2006-02-08 Thread Setiaji
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

Re: [Axapta-Knowledge-Village] Temporary table

2006-02-08 Thread Paulius
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

[Axapta-Knowledge-Village] temporary table

2006-01-05 Thread niphawan sungnoi
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

RE : [Axapta-Knowledge-Village] Temporary table

2005-02-21 Thread Steeve Gilbert
;     } } 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

Re: RE : [Axapta-Knowledge-Village] Temporary table

2005-02-21 Thread Ashi Singh
ngh [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 tol

[Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Steeve Gilbert
(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){

Re: [Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Varden Morris
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

Re: [Axapta-Knowledge-Village] Temporary table

2005-02-18 Thread Ashi Singh
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

[Axapta-Knowledge-Village] Temporary Table cannot be set for security setup

2004-12-16 Thread Sonny Wibawa Adi
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,