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

Fri, 27 Jan 2006 01:13:08 -0800


Christoph,

Why do you not want to use another table buffer?

Why not modify the code as follows?
      While
      Select CT
      Order by Name
      {
            Print CT.AccountNum;
      }
      Pause;



Barry.


-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Christoph
Malherbe
Sent: Thursday, 26 January 2006 10:24 PM
To: [email protected]
Subject: RE: [development-axapta] Re: Resorting a table buffer

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
YAHOO! GROUPS LINKS



Reply via email to