Click here to Skip to main content
16,020,249 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: Array Problem. Pin
Richard MacCutchan2-Dec-11 23:14
mveRichard MacCutchan2-Dec-11 23:14 
GeneralRe: Array Problem. Pin
janaswamy uday3-Dec-11 0:18
janaswamy uday3-Dec-11 0:18 
GeneralRe: Array Problem. Pin
Richard MacCutchan3-Dec-11 0:25
mveRichard MacCutchan3-Dec-11 0:25 
AnswerRe: Array Problem. Pin
Addy Tas4-Dec-11 10:08
Addy Tas4-Dec-11 10:08 
Questiongetline Pin
jkirkerx2-Dec-11 11:21
professionaljkirkerx2-Dec-11 11:21 
AnswerRe: getline Pin
Chris Losinger2-Dec-11 11:45
professionalChris Losinger2-Dec-11 11:45 
GeneralRe: getline Pin
jkirkerx2-Dec-11 12:19
professionaljkirkerx2-Dec-11 12:19 
AnswerI'm stuck, not sure which direction to go Pin
jkirkerx2-Dec-11 19:16
professionaljkirkerx2-Dec-11 19:16 
I got the getline to work, but I can't figure out how to advance to the next line.

And even if I can get to the next line, I can't figure out how to build the buffer with sql command text until I reach GO. Sure like that stringbuilder in asp.net.

The wifstream was suppose to return the unicode chars from the file, but I get ansi chars.

I'm close here, just need lots of refinement.

Any ideas are welcomed.

C#
// Load the SQL Server Commands
    std::wifstream *sqlDBFile = new std::wifstream;
    sqlDBFile->open(szFilePath);

    // if the file stream opened
    if (sqlDBFile->is_open() ) {

        // While file stream is in memory
        while (sqlDBFile->good() ) {
            // Make a temp sql command buffer
            WCHAR *pzSQLCommand = new WCHAR[1024];

            while (sqlDBFile->good() ) {
                // read the line of text
                WCHAR szAnsiBuffer[1024];
                sqlDBFile->getline(szAnsiBuffer, 1024, L'\n');

                int jdx = 0;
                WCHAR *szBufferLine = new WCHAR[1024];
                for (int i = 2; i < 1024; ++i) {
                    szBufferLine[jdx] = szAnsiBuffer[i];
                    i++;
                    jdx++;
                }
                int iLength = wcslen(szBufferLine);
                szBufferLine[iLength] = L'\0';

                // if text != GO, add to buffer
                if ((wcsncmp( szBufferLine, L"GO", wcslen(L"GO") )) != 0) {
                    wcsncat_s(pzSQLCommand, wcslen(pzSQLCommand), szBufferLine, wcslen(szBufferLine) );

                    pzSQLCommand[wcslen(pzSQLCommand) + 1] = L'\0';
                    break;
                }
                else {
                    // if text = GO, terminate the buffer and execute the buffered command
                    hr = pICommandText->SetCommandText( DBGUID_DBSQL, pzSQLCommand );
                    hr = pICommandText->QueryInterface( IID_ICommandProperties, ( void ** ) &pICommandProperties );
                    hr = pICommandText->Execute( NULL, IID_IRowset, NULL, &cRowsAffected, ( IUnknown ** ) &pIRowset );

                }
            }
        }

GeneralRe: I'm stuck, not sure which direction to go Pin
Richard MacCutchan3-Dec-11 0:03
mveRichard MacCutchan3-Dec-11 0:03 
GeneralRe: I'm stuck, not sure which direction to go Pin
jkirkerx3-Dec-11 8:00
professionaljkirkerx3-Dec-11 8:00 
GeneralNextline Pin
jkirkerx3-Dec-11 8:26
professionaljkirkerx3-Dec-11 8:26 
GeneralRe: Nextline Pin
Richard MacCutchan3-Dec-11 9:13
mveRichard MacCutchan3-Dec-11 9:13 
Questioni can't load dll builded in debug unicode,what's difference between 'debug' and 'debug unicode'? Pin
Member 77984732-Dec-11 5:06
Member 77984732-Dec-11 5:06 
AnswerRe: i can't load dll builded in debug unicode,what's difference between 'debug' and 'debug unicode'? Pin
JackDingler2-Dec-11 5:19
JackDingler2-Dec-11 5:19 
AnswerRe: i can't load dll builded in debug unicode,what's difference between 'debug' and 'debug unicode'? Pin
Erudite_Eric2-Dec-11 5:44
Erudite_Eric2-Dec-11 5:44 
AnswerRe: i can't load dll builded in debug unicode,what's difference between 'debug' and 'debug unicode'? Pin
Richard MacCutchan2-Dec-11 6:20
mveRichard MacCutchan2-Dec-11 6:20 
Questionclass object as parameter of Template Function Pin
002comp2-Dec-11 0:29
002comp2-Dec-11 0:29 
QuestionRe: class object as parameter of Template Function Pin
CPallini2-Dec-11 0:43
mveCPallini2-Dec-11 0:43 
AnswerRe: class object as parameter of Template Function Pin
002comp2-Dec-11 0:50
002comp2-Dec-11 0:50 
QuestionRe: class object as parameter of Template Function Pin
CPallini2-Dec-11 0:53
mveCPallini2-Dec-11 0:53 
AnswerRe: class object as parameter of Template Function Pin
Chris Losinger2-Dec-11 1:29
professionalChris Losinger2-Dec-11 1:29 
GeneralRe: class object as parameter of Template Function Pin
CPallini2-Dec-11 1:32
mveCPallini2-Dec-11 1:32 
AnswerRe: class object as parameter of Template Function Pin
002comp2-Dec-11 1:30
002comp2-Dec-11 1:30 
GeneralRe: class object as parameter of Template Function Pin
CPallini2-Dec-11 1:44
mveCPallini2-Dec-11 1:44 
GeneralRe: class object as parameter of Template Function Pin
Addy Tas4-Dec-11 10:45
Addy Tas4-Dec-11 10: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.