Click here to Skip to main content
15,562,256 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
Question[ win32 ][ code::block's ] game 1 error ? Pin
bluatigro26-Oct-17 0:19
bluatigro26-Oct-17 0:19 
AnswerRe: [ win32 ][ code::block's ] game 1 error ? Pin
CPallini26-Oct-17 1:06
mveCPallini26-Oct-17 1:06 
AnswerRe: [ win32 ][ code::block's ] game 1 error ? Pin
Richard MacCutchan26-Oct-17 1:16
mveRichard MacCutchan26-Oct-17 1:16 
GeneralRe: [ win32 ][ code::block's ] game 1 error ? Pin
bluatigro31-Oct-17 0:50
bluatigro31-Oct-17 0:50 
GeneralRe: [ win32 ][ code::block's ] game 1 error ? Pin
Richard MacCutchan31-Oct-17 1:13
mveRichard MacCutchan31-Oct-17 1:13 
QuestionCDBVariant type problem Pin
_Flaviu25-Oct-17 3:06
_Flaviu25-Oct-17 3:06 
QuestionRe: CDBVariant type problem Pin
Richard MacCutchan25-Oct-17 3:34
mveRichard MacCutchan25-Oct-17 3:34 
AnswerRe: CDBVariant type problem Pin
_Flaviu25-Oct-17 5:43
_Flaviu25-Oct-17 5: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 7:19
mveRichard MacCutchan25-Oct-17 7:19 
GeneralRe: CDBVariant type problem Pin
leon de boer25-Oct-17 9:42
leon de boer25-Oct-17 9:42 
PraiseRe: CDBVariant type problem Pin
_Flaviu26-Oct-17 21:42
_Flaviu26-Oct-17 21:42 
QuestionRe: CDBVariant type problem Pin
David Crow25-Oct-17 4:01
David Crow25-Oct-17 4:01 
PraiseRe: CDBVariant type problem Pin
_Flaviu25-Oct-17 5:23
_Flaviu25-Oct-17 5:23 
AnswerRe: CDBVariant type problem Pin
Randor 25-Oct-17 17:30
professional Randor 25-Oct-17 17:30 
AnswerRe: CDBVariant type problem Pin
Victor Nijegorodov26-Oct-17 11:06
Victor Nijegorodov26-Oct-17 11:06 
Questionc Pin
Member 1348311524-Oct-17 8:24
Member 1348311524-Oct-17 8:24 
AnswerRe: c Pin
Chris Losinger24-Oct-17 8:51
professionalChris Losinger24-Oct-17 8:51 
Rant[REPOST] c Pin
Richard Deeming24-Oct-17 10:46
mveRichard Deeming24-Oct-17 10:46 
Questionalgorithm for an optimization problem Pin
Member 1347898622-Oct-17 10:31
Member 1347898622-Oct-17 10:31 
AnswerRe: algorithm for an optimization problem Pin
OriginalGriff22-Oct-17 10:32
mvaOriginalGriff22-Oct-17 10:32 
GeneralRe: algorithm for an optimization problem Pin
Member 1347898622-Oct-17 11:08
Member 1347898622-Oct-17 11:08 
GeneralRe: algorithm for an optimization problem Pin
OriginalGriff22-Oct-17 11:16
mvaOriginalGriff22-Oct-17 11:16 
PraiseRe: algorithm for an optimization problem Pin
David Crow22-Oct-17 17:45
David Crow22-Oct-17 17:45 
GeneralRe: algorithm for an optimization problem Pin
Bram van Kampen22-Oct-17 18:40
Bram van Kampen22-Oct-17 18:40 
AnswerRe: algorithm for an optimization problem Pin
CPallini22-Oct-17 23:17
mveCPallini22-Oct-17 23: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.