PRB: CDBVariant Contains Wrong BOOL Value When Calling CRecordset::GetFieldValue() (230491)

MORE INFORMATION

The following steps use the SQL Server Pubs database as an example:

Steps to Reproduce Behavior

1. Create an MFC Single Document Interface project with database header file support.
2. Create a menu item or button event handler.
3. Type the following code in the handler and change the connect string to reflect your SQL Server database and you user account:

   	CDatabase db;
   	db.OpenEx(_T("Driver=SQL Server;Server=(local);Database=Pubs;UID=<username>;PWD=<strong password>;"));
   
   	CRecordset rs;
   	rs.m_pDatabase = &db;
   	rs.Open(CRecordset::forwardOnly, _T("SELECT * FROM authors"));
   
   	CDBVariant varField;
   	rs.GetFieldValue(_T("contract"),varField);
   	BOOL boolValue = varField.m_boolVal;
   
   						

4. Observe the value of boolValue. It will be incorrect.

Workaround

Use SQL_C_UTINYINT or SQL_C_SLONG explicitly in the CRecordset::GetFieldValue() method. Replace the last two lines of the previous code block with one of the following:

	rs.GetFieldValue(_T("contract"),varField,SQL_C_UTINYINT);
	BYTE byteValue = varField.m_chVal;
				

-or-

	rs.GetFieldValue(_T("contract"),varField,SQL_C_SLONG);
	BOOL boolValue = varField.m_boolVal;