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
Sharing the knowledge on Axapta.
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.
