Click here to Skip to main content
15,905,874 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
Question[ win32 ][ code::block's ] game 1 error ? Pin
bluatigro25-Oct-17 23:19
bluatigro25-Oct-17 23:19 
AnswerRe: [ win32 ][ code::block's ] game 1 error ? Pin
CPallini26-Oct-17 0:06
mveCPallini26-Oct-17 0:06 
AnswerRe: [ win32 ][ code::block's ] game 1 error ? Pin
Richard MacCutchan26-Oct-17 0:16
mveRichard MacCutchan26-Oct-17 0:16 
GeneralRe: [ win32 ][ code::block's ] game 1 error ? Pin
bluatigro30-Oct-17 23:50
bluatigro30-Oct-17 23:50 
GeneralRe: [ win32 ][ code::block's ] game 1 error ? Pin
Richard MacCutchan31-Oct-17 0:13
mveRichard MacCutchan31-Oct-17 0:13 
QuestionCDBVariant type problem Pin
_Flaviu25-Oct-17 2:06
_Flaviu25-Oct-17 2:06 
QuestionRe: CDBVariant type problem Pin
Richard MacCutchan25-Oct-17 2:34
mveRichard MacCutchan25-Oct-17 2:34 
AnswerRe: CDBVariant type problem Pin
_Flaviu25-Oct-17 4:43
_Flaviu25-Oct-17 4:43 
I re-written the FormatData method:
C++
CString CMyDoc::FormatData(CDBVariant* pDBVariant)
{
	CString sRet;

	switch(pDBVariant->m_dwType)
	{
	case DBVT_LONG:
		TRACE("DBVT_LONG\n");
		sRet.Format(_T("%d"), pDBVariant->m_lVal);
		break;
	case DBVT_DOUBLE:
		TRACE("DBVT_DOUBLE\n");
		break;
	case DBVT_SHORT:
		TRACE("DBVT_SHORT\n");
		break;
	case DBVT_SINGLE:
		TRACE("DBVT_SINGLE\n");
		break;
	case DBVT_STRING:
		TRACE("DBVT_STRING\n");
		break;
	case DBVT_ASTRING:
		TRACE("DBVT_ASTRING\n");
		sRet = *pDBVariant->m_pstring;
		break;
	case DBVT_DATE:
		TRACE("DBVT_DATE\n");
		break;
	case DBVT_WSTRING:
		TRACE("DBVT_WSTRING\n");
		CStringW wstring = *pDBVariant->m_pstringW;
		sRet = CString(wstring);
		break;
	}

	return sRet;
}


I have the following SQL:
C++
SELECT nUser FROM my_table

In DB, nUser has "int" type. The result in FormatData method: DBVT_LONG

I have another SQL:
C++
SELECT dValue FROM my_table

In DB, dValue has "decimal (10.2)" type. The result in FormatData method: DBVT_ASTRING !? Why ?
I have another SQL:
C++
SELECT sName FROM my_table

In DB, dValue has "varchar(1024)" type. The result in FormatData method: DBVT_ASTRING - correct.

I noticed that any king of column type in DB, except "int" type, return DBVT_ASTRING in FormatData method ... why ?

I have tried to get data with CRecordset as dynaset, snaphot and dynamic ... every one of them had the same result ...
GeneralRe: CDBVariant type problem Pin
Richard MacCutchan25-Oct-17 6:19
mveRichard MacCutchan25-Oct-17 6:19 
GeneralRe: CDBVariant type problem Pin
leon de boer25-Oct-17 8:42
leon de boer25-Oct-17 8:42 
PraiseRe: CDBVariant type problem Pin
_Flaviu26-Oct-17 20:42
_Flaviu26-Oct-17 20:42 
QuestionRe: CDBVariant type problem Pin
David Crow25-Oct-17 3:01
David Crow25-Oct-17 3:01 
PraiseRe: CDBVariant type problem Pin
_Flaviu25-Oct-17 4:23
_Flaviu25-Oct-17 4:23 
AnswerRe: CDBVariant type problem Pin
Randor 25-Oct-17 16:30
professional Randor 25-Oct-17 16:30 
AnswerRe: CDBVariant type problem Pin
Victor Nijegorodov26-Oct-17 10:06
Victor Nijegorodov26-Oct-17 10:06 
Questionc Pin
Member 1348311524-Oct-17 7:24
Member 1348311524-Oct-17 7:24 
AnswerRe: c Pin
Chris Losinger24-Oct-17 7:51
professionalChris Losinger24-Oct-17 7:51 
Rant[REPOST] c Pin
Richard Deeming24-Oct-17 9:46
mveRichard Deeming24-Oct-17 9:46 
Questionalgorithm for an optimization problem Pin
Member 1347898622-Oct-17 9:31
Member 1347898622-Oct-17 9:31 
AnswerRe: algorithm for an optimization problem Pin
OriginalGriff22-Oct-17 9:32
mveOriginalGriff22-Oct-17 9:32 
GeneralRe: algorithm for an optimization problem Pin
Member 1347898622-Oct-17 10:08
Member 1347898622-Oct-17 10:08 
GeneralRe: algorithm for an optimization problem Pin
OriginalGriff22-Oct-17 10:16
mveOriginalGriff22-Oct-17 10:16 
PraiseRe: algorithm for an optimization problem Pin
David Crow22-Oct-17 16:45
David Crow22-Oct-17 16:45 
GeneralRe: algorithm for an optimization problem Pin
Bram van Kampen22-Oct-17 17:40
Bram van Kampen22-Oct-17 17:40 
AnswerRe: algorithm for an optimization problem Pin
CPallini22-Oct-17 22:17
mveCPallini22-Oct-17 22:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.