Just my thoughts.
What is the problem if you use
while select CustTable
<ur index>
group by AccountNuM, Name Asc
{
<your Code>
}
Would that survive your purpose by grouping them in the same order?
Best of luck,
subbu
Varden Morris <[EMAIL PROTECTED]> wrote:
Hi Vishnu,Use the Group By clause for AccountNum field and then use and index for the Name field. Something like:
while select custTable index NameIdx Group by AccountNum
{
<Code goes here>;
}
Where NameIdx is the index on the Name field.
Hope this help.
Varden Morris
Girish Bhatkal <[EMAIL PROTECTED]> wrote:X++ DOES NOT allow to use both in the same select
statement. this is one of the main difference between
X++ and SQL.
--- vishnu verma <[EMAIL PROTECTED]>
wrote:
> hi all,
> I am having one problem.
> I want to group the records based on customer
> account and sort them by their names.how can i do
> that.If any one can help me then i'll be highly
> obliged.
> Thanks
> Vishnu Prakash Verma.
>
>
> ---------------------------------
> Check out Yahoo! India Rakhi Special for Rakhi
> shopping, contests and lots more.
> http://in.promos.yahoo.com/rakhi/index.html
___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Start your day with Yahoo! - make it your home page
Sharing the knowledge on Axapta.
SPONSORED LINKS
Business finance course | Business to business finance | Small business finance |
Business finance consultant | Business finance magazine | Business finance schools |
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.