SQL Select Statement for COUNT in Ax

I am using the same table Bill_TabMethod for SQL Count.

Step 1. Write the below SQL Select statement in a Job like below

CODE:

static void SQLCount(Args _args)

{

Bill_TabMethod btm;

while select count(CustName) from btm

print “Number of Records :  “,btm.CustName;

pause;

}

Step 2. Run the code you will get the Result as

Number of Records : 11

Yes you have done…

Advertisements

One comment on “SQL Select Statement for COUNT in Ax

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s