Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
COURSE of the MONTH
12 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
CRecordSet and SQL after CRecordSet open
Posted on 1998-08-26
Is it possible to make another SQL query AFTER the CRecordset open statement.
I know that it is possible to use the
m_strFilter (to add a where statment) and the m_strSort
(for a ORDER BY statement). Then by calling the requery, the CRecordset instance will be updated accordingly.
But if you want to carry out a Select Count(*) followed by a Select <Column>, is this possible to do this with out closing and reopening the Crecordset instance with the appropriate query string and to not use any API functions.
I know that it is possible to use the
m_strFilter (to add a where statment) and the m_strSort
(for a ORDER BY statement). Then by calling the requery, the CRecordset instance will be updated accordingly.
But if you want to carry out a Select Count(*) followed by a Select <Column>, is this possible to do this with out closing and reopening the Crecordset instance with the appropriate query string and to not use any API functions.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
1 Comment
Simple answer: No. Changing the select statment is a fairly major change to the query, and would require _at least_ a 'requery' call. You can simulate the select count by opening the recordset to the select <column> query, doing a move first, and then moveNext while incrementing a counter until you hit the end of the table. This is actually faster than it sounds on most (< 100,000 records) db's on most systems.
However -- you may want to look into the CDao* (e.g. CDaoRecordset) classes. They usually have all the functionality that the ODBC classes have, plus more. If you are working with an Access database, they are definately the way to go. The CDaoRecordset has a working count function, so you can just select <column>, move to the last record, and get the record count, thus removing the need for your first query.
However -- you may want to look into the CDao* (e.g. CDaoRecordset) classes. They usually have all the functionality that the ODBC classes have, plus more. If you are working with an Access database, they are definately the way to go. The CDaoRecordset has a working count function, so you can just select <column>, move to the last record, and get the record count, thus removing the need for your first query.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Introduction:
Ownerdraw of the grid button. A singleton class implentation and usage.
Continuing from the fifth article about sudoku.
Open the project in visual studio.
Go to the class view – CGridButton should be visible as a class. R…
Introduction:
Database storage, where is the exe actually on the disc? Playing a game selected randomly (how to generate random numbers). Error trapping with try..catch to help the code run even if something goes wrong.
Continuing from the seve…
This video will show you how to get GIT to work in Eclipse.
It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
Suggested Courses
Course of the Month12 days, 8 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.