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 development-axapta@yahoogroups.com, "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]
>







SPONSORED LINKS
Computer part Programming languages Microsoft axapta
Support exchange


YAHOO! GROUPS LINKS




Reply via email to