one way is to create a new index on the table (in Axapta) with the field you
want to sort by and then use the order by in the select or the index hint.
Without an index, particularly on a name field, would make the select far
too slow.

On 1/25/06, 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<http://groups.yahoo.com/gads?t=ms&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11w> Programming
> languages<http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wapXFmKisbQ> Microsoft
> axapta<http://groups.yahoo.com/gads?t=ms&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud02Fg>  Support
> exchange<http://groups.yahoo.com/gads?t=ms&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITTUeqA>
>  ------------------------------
> YAHOO! GROUPS LINKS
>
>
>    -  Visit your group "development-axapta<http://groups.yahoo.com/group/development-axapta>"
>    on the web.
>
>    -  To unsubscribe from this group, send an email to:
>     [EMAIL PROTECTED]<[EMAIL PROTECTED]>
>
>    -  Your use of Yahoo! Groups is subject to the Yahoo! Terms of
>    Service <http://docs.yahoo.com/info/terms/>.
>
>
>  ------------------------------
>


[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