RE: [Axapta-Knowledge-Village] Temp tables
Everything going well on this side of the world. :) There is an easy way to figure out whether the code is running on server, I think there is a variable/function called isAOS or something like that. I don't have access to a system right now, but you can search for it. I agree with Moris regarding sum() function on temp tables, they will get degraded. Regards harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: Friday, July 30, 2010 10:26 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Temp tables Hi and thanks Harry for that, never thought to try it that way :) Thanks and good to hear from you after so long, hope things are well with you and your family :) From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Harry Deshpande Sent: 31 July 2010 13:14 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Temp tables The easiest way I can think of is, Write a method on the table, put a breakpoint. On the AOS configuration disable breakpoints running on server. Now execute the method, if it hits the break point then it is running on client otherwise on server. Regards Harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: Friday, July 30, 2010 10:05 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Temp tables Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% ... I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James
RE: [Axapta-Knowledge-Village] Temp tables
The easiest way I can think of is, Write a method on the table, put a breakpoint. On the AOS configuration disable breakpoints running on server. Now execute the method, if it hits the break point then it is running on client otherwise on server. Regards Harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: Friday, July 30, 2010 10:05 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Temp tables Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% ... I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James
RE: [Axapta-Knowledge-Village] Temp tables
Hi and thanks Harry for that, never thought to try it that way J Thanks and good to hear from you after so long, hope things are well with you and your family J From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of Harry Deshpande Sent: 31 July 2010 13:14 To: Axapta-Knowledge-Village@yahoogroups.com Subject: RE: [Axapta-Knowledge-Village] Temp tables The easiest way I can think of is, Write a method on the table, put a breakpoint. On the AOS configuration disable breakpoints running on server. Now execute the method, if it hits the break point then it is running on client otherwise on server. Regards Harry From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of James Flavell Sent: Friday, July 30, 2010 10:05 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Temp tables Hi everyone once again Can someone tell me for temp tables in AX2009 are they for sure always created/stored and processed on the AOS server? Supposedly http://www.axaptapedia.com/Temporary_tables says the temp table is put on the hard disk of server or client based on where the first record is inserted. In AX2009 I assume all code is executed on the server but am not 100% . I am thinking the code in a form might well be executed on the client and hence my temp table end up on the client!??? My specific situation is to do with Arrival Overview form that populates some temp tables. Is there any way I can check or test where the temp table is being created? Thanks as ever James