RE: [development-axapta] Re: Resorting a table buffer

Thu, 26 Jan 2006 06:04:16 -0800

Hi Gonzalo,

Thank you for responding.

What I'm after is a function/statement which will change the sort order of
the data in the table buffer after the table buffer was populated with data.

Regards,

Christoph.

-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of gonzalo_edo
Sent: 26 January 2006 02:27 AM
To: [email protected]
Subject: [development-axapta] Re: Resorting a table buffer

You should consider a cluster index to keep your records sorted as
you want, you perfectly could change the order of the records in the
Ct buffer, but you need an index, otherwise the query will take so
long because the database motor will create a temporary index to
handle the query.

Regards Gonzalo.



--- In [email protected], "Christoph Malherbe"
<[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> 
>
> Please consider the following:
>
> 
>
> static void ProcessCustomers(CustTable ct)
>
> {
>
>     while (ct)
>
>     {
>
>         print ct.AccountNum;
>
>         next ct;
>
>     }
>
> 
>
>     pause;
>
> }
>
> 
>
> This is a hypothetical scenario where the method receives a table
buffer as
> parameter. The table buffer is sorted by "AccountNum desc". Before
> processing the table buffer with the "while" statement, I'd like
to change
> the sort order to "Name asc". Is this something that can be done
without
> having to re-execute the select that populated the table buffer in
the first
> place?
>
> Regards,
>
> Christoph Malherbe
>
> 
>
>
>
> [Non-text portions of this message have been removed]
>







Yahoo! Groups Links
YAHOO! GROUPS LINKS



Reply via email to