How to count records in a Query or Form

It seems that when I have a query with more than 1 datasource, the SysQuery::countTotal() will give you the sum of the RecId values of all the records.

example X++ Code

wrote by : Jimmy Oct  12th 2010

in a query

static void Jimmy_queryCountTotal(Args _args)
{
    query                   q = new query();
    queryRun                qr;
    queryBuildDataSource    qbds;
;
    qbds = q.addDataSource(tablenum(VendTable));
    qr = new queryRun(q);
    print sysquery::countTotal(qr);
    //formdatasource.numberOfRowsLoaded();this method Apply for Form
    pause;
}

in a Form

public void executeQuery()
{
;
      super();
      info(int2str(SysQuery::countTotal(VendTable_DS.queryRun())));//this.queryRun())));
      //info(int2str(VendTable_DS.numberOfRowsLoaded()));
}