reading a record

How can I read a record from an open database by sending a query.

example:
I open the database
I open a recordset with an SQL query
I read a single column (the only one retrieved)
I do some non database stuff
I make a new query and execute it
I read another column(the only one retrieved)
.
.
.
And so on
I then close the database.

please help

[Paley]

There is no definitive answer to this question, other than 'you can do it in myriad ways'.

What database are you using?
How are you connecting to the database?

[Burlacu Ovidiu]

Do this:

CDatabase db;
db.Open("your_db");
CRecordset rs(&db);
rs.Open(CRecordset::forwardOnly, sqlString );

CDBVariant value;

while( !rs.IsEOF() )
{
rs.GetFieldValue( (int)0, value, TYPE_OF_VALUE );//for TYPE_OF_VALUE see help
//do something with the value;
rs.MoveNext();
}

rs.Close();
db.Close();

here is the code I am using on a MS Access db:

CDatabase dbm1;
CRecordset rsm1(&dbm1);
if (rsm1.IsOpen()) rsm1.Close();
if (dbm1.IsOpen()) dbm1.Close();
strConnect = _T("ODBC;DSN=mydb;UID=;PW=;");
dbm1.Open("",FALSE,FALSE,strConnect,FALSE);

strSQL = _T("SELECT answer FROM Table WHERE number=10 ");
rsm1.Open(CRecordset::snapshot, strSQL);
rsm1.GetFieldValue(0, m_string);



now, I want to pick another "number" that is not in sequence and get the "answer" without having to close and reopen the database

[Paley]

Use a parameter in your SQL string, you can then just requery to get the new result set

Could you give me a snipet of code as an example (for the requery)

Thanx

I know that I must requery, I dont know how.
I know that I can use:
rsm1.Requery();
but how do I set a new SQL string befor I do this