asked on

Get the record count by C++ and OLEDB.

Can someone give me the sample of code in C++ that show me how to get the record count of the table in database by using oledb commands?

Thanks.

AlexNek

Run SQL command like this one
select count(*) as records_Number from <table Name> [Where ....]

ASKER CERTIFIED SOLUTION

bijopuli

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Deepu Abraham

CString strCommand;
strCommand.Format(_T("SELECT COUNT(*) FROM '%s';"), szTableName);
Then EecuteQuery() should retrive the count of the records of a prticualr table.

Best Regards,
DeepuAbrahamK

bsuttiratana

ASKER

What I have in mind is I will have a method which will have the sql statement as input and return the number of records.

szSqlStr should be the sql statement like "select count(*) from MyTable". MyTable will be any table depends on the caller.

LONG ExecCountSql(LPCSTR szSqlStr );
{

}

Bijo.

How can I construct the command "pICommandText" from the sql statement and how can I get the record count from your code?

The tables might be very large. I am concern abount the performance. Do you think your code will impact the performance? What I need is just the record count. Nothing else.