Click here to Skip to main content
15,886,067 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
Questionalogaritm for mini calender project Pin
Member 1348043227-Oct-17 3:21
Member 1348043227-Oct-17 3:21 
AnswerRe: alogaritm for mini calender project Pin
CPallini27-Oct-17 3:27
mveCPallini27-Oct-17 3:27 
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 
Hi all of you. I come here hoping to solve a problem that I have met on retrieving data from DB (SQL Server).

I retrieve data in the following way:
C++
pRs->GetFieldValue(i, *pDBVariant);

nothing special ... (pRS is CRecordset*, and pDBVariant is CDBVariant*).
And this is method to format data:
C++
CString CMyDoc::FormatData(CDBVariant* pDBVariant)
{
	CString sRet;

	do
	{
		if(NULL == pDBVariant)
			break;
		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;
		}
	}
	while(FALSE);

	return sRet;
}

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

nUser has int SQL data type, and when I test this data with CMyDoc::FormatData, the returning data type are: DBVT_LONG

Ok, let take another SQL:

C++
SELECT dVAT FROM my_table;

dVAT has decimal (10.2) SQL data type, and when I test this data with CMyDoc::FormatData, the returning data type are: DBVT_ASTRING ... why ?

I have tested another SQL:
C++
SELECT sName FROM my_table;

sName has string SQL data type, and when I test this data with CMyDoc::FormatData, the returning data type are: DBVT_ASTRING, which are ok ...

but, excepting int SQL data type, all other SQL data type are having DBVT_ASTRING when I test this with CMyDoc::FormatData ... why ?

Can you help me ?

Thank you.
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 
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 

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.