C / C++ / MFC

Richard MacCutchan wrote:

C# programmers dabblers apparently have no clue as to ...

Le@rner wrote:

i just want to know, if i inter-change my office document file to each other, like .doc, to .xls or .ppt

Le@rner wrote:

i am reading file properties,

typedef std::codecvt<wchar_t, wchar_t, mbstate_t> nullcodecvt;
const nullcodecvt &conv =
std::use_facet<nullcodecvt>(std::wcin.getloc());
const std::locale from(std::wcin.getloc(), &conv);

std::wifstream *sqlDBFile = new std::wifstream;
sqlDBFile->open( szFilePath, std::ios_base::in );

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

    if (_wcsicmp(szEncoding, L"UTF8") == 0 ) {
        sqlDBFile->seekg(3, std::ios::beg);
    }

    // Make a temp sql command buffer
    WCHAR *pzSQLCommand = new WCHAR[8192];
    wcsncpy_s(pzSQLCommand, 8192, L"-- SQL Command Buffer --\n", wcslen(L"-- SQL Command Buffer --\n") );

    // While file stream is in memory
    while (sqlDBFile->good() ) {
        while (!sqlDBFile->eof() ) {
            WCHAR szCommandLine[1024];
            for (int i = 0; i<1024; ++i) {
                szCommandLine[i] = 0xcccc;
            }

            sqlDBFile->getline(szCommandLine, 1024);

            // Check for Comment Line
            if (szCommandLine[0] == 0x002d)
                    continue;
            // Check for Unknown Line - Can't Remember this one
            if ((szCommandLine[0] == 0x0000) && (szCommandLine[1] == 0x0000))
                continue;
            // Check for Blank Line
            if ((szCommandLine[0] == 0x0000) && (szCommandLine[1] == 0xcccc))
                continue;

            if (_wcsicmp(szCommandLine, L"GO") == 0 ) {
                // 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 );

                // Clear the main command buffer for next use
                for (int i = 0; i<8192; ++i) {
                    pzSQLCommand[i] = 0xcccc;
                }
            }
            else {
                // if text != GO, cat to main command buffer
                szCommandLine[wcslen(szCommandLine)] = L'\0';
                wcsncat_s(pzSQLCommand, 8196, szCommandLine, wcslen(szCommandLine) );
                continue;
            }
        }
    }

    delete pzSQLCommand;

    // close the sql command file
    sqlDBFile->close();
    sqlDBFile = NULL;
}