C / C++ / MFC

BSTR    b = SysAllocString(_T("This is a 32k string"));
TCHAR   left[11],
        right[11];

_tcsncpy(left, b, 10);
left[10] = '\0';
_tcsncpy(right, b + 10, 10);
right[10] = '\0';

"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)

<br />
CDatabase db;<br />
db.OpenEx("XXX-ODBC DATASOURCE MAPPING NAME GOES HERE-XXX");<br />
CRecordset rs(&db);<br />
CString QueryString;<br />
CString data;			   // holds data from database<br />
<br />
QueryString = "SELECT * FROM tablename"; // SQL query goes here<br />
<br />
rs.Open(AFX_DB_USE_DEFAULT_TYPE, QueryString);<br />
<br />
// this loop will execute once for each record returned by the query in QueryString<br />
while(! rs.IsEOF())<br />
{<br />
   rs.GetFieldValue("FieldName", data);      // Tell it which field you want assigned to what variable<br />
   rs.MoveNext();  // move to the next record<br />
<br />
   // now do whatever you want with the value in data - it now contains what was in the database field specified in the GetFieldValue call<br />
}<br />
<br />
rs.Close();<br />
db.Close();<br />

"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)

"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)

"The pointy end goes in the other man." - Antonio Banderas (Zorro, 1998)