i'm using Database Object (CDatabas 1

[jl3574]

i'm using Database Object (CDatabase) in Visual C++, to connect to ms sql server..

sprintf(sql, "insert into TABLE_STYLES(STYLE_NAME) values('%s')",temp1);
theDb->ExecuteSQL(sql);

i use an sample statment like this to put data info the database.

my question is simple
how do i extract a value from the sql database and put it in a variable so i can use it in my program?

 

[Korach]

I didn't do it ever, but I found this:
You need to use CRecordSet because ExecuteSQL return no rows.
You can find many examples. Here is one:
//open database
CString strSQL;
m_cbTable.GetLBText(nCurSel, strSQL);
strSQL = _T("SELECT * FROM &quot + strSQL; // you can set any query

// Open the recordset
rs.Open(CRecordset::snapshot, strSQL, CRecordset::readOnly | CRecordset::useMultiRowFetch);

From the recordset you can get your answer, look for examples.