ODBC navigation problem

Question

1.00/5 (1 vote)

See more:

C++

int counter=0;
int Field_One=0;
bool end = false
selection[0]= mpset->First_Field

mpset->MoveFirst();

While(!end)

{
if(selection[counter] >0)
    {
     Field_One++;
    }

mpset->MoveNext();
end = mpset->IsEOF();
}

Here is a sample of the code. It reads the first field of each record and should move on to next record until all records completed.

Hi all

I have a problem navigating my access DB , I am using the commands MoveFirst(); and MoveNext(); and checking for end of file with m_pSet->IsEOF();

What is happenng is I am running the prog and I am only reading the first record values repeatedly on running the program even though EndofFile gets set at the end of the recordset. So it is going through the recordset but not acknowledging the values in each record only the first.

I rerun the program and it goes to the last record. I have 21 fields in each record.

Can anybody help please ?

Posted 22-Feb-13 10:07am

Jakey777

Updated 23-Feb-13 0:06am

v2

Add a Solution

Comments

[no name] 22-Feb-13 17:17pm

Post some code that demonstrates your problem.

CPallini 23-Feb-13 6:09am

Where are you actually reading the values? What is 'While'?

Jakey777 23-Feb-13 6:21am

While end is not true, a loop to go through the records

Jakey777 23-Feb-13 6:21am

Reading from access 97 DB table

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

KarstenK · Accepted Answer · 2013-02-26T01:59:00

Solution 1

you only set the pointer of your reader - you need to "read" the data from the actual position in your data:

maybe this code needs to be added

selection[counter]= mpset->First_Field

Posted 26-Feb-13 1:59am

KarstenK

Comments

Jakey777 26-Feb-13 10:30am

Thanks KarstenK I needed to get this code inside the while loop as I was only reading the data from the first record into selection and then going throught the recordset. On rerun of prog record pointer was on last record so this was read in.