Using temp table here is quiet expensive with regards to performance in production environment. You have to use QueryBuild* objects here and change the query on button click.
--- On Mon, 16/8/10, pranam mukher <pranam_shub...@yahoo.co.in> wrote: From: pranam mukher <pranam_shub...@yahoo.co.in> Subject: Re: [development-axapta] select query and grid To: development-axapta@yahoogroups.com Date: Monday, 16 August, 2010, 8:36 AM yes its very much possible. put the results of query in ur temp table, and add it as a datasource, to ur form, then u can navigate. --- On Tue, 10/8/10, ramankt2001 <raman_...@hotmail.com> wrote: From: ramankt2001 <raman_...@hotmail.com> Subject: [development-axapta] select query and grid To: development-axapta@yahoogroups.com Date: Tuesday, 10 August, 2010, 2:28 AM We are on Axapta 3.0 sp3. I've a query, the guts of which is: select T1.F1, T1.F2, T2.F3, T2.F4 from T1 where some-criteria join T2 where some-other-criteria I would like to present the results of this query (four fields) in a form's grid and iterate through the grid in button control's click method. Is it possible? Thanks. [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
